ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 3 question 13 discussion

Actual exam question from Microsoft's PL-300
Question #: 13
Topic #: 3
[All PL-300 Questions]

HOTSPOT -
You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Background color -
To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.


Box 2: Rules -
To format cell background or font color by rules, in the Format by field of the Background color or Font color dialog box, select Rules.

Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
by ecwang at Sept. 19, 2022, 2:16 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
RichardOgoma
Highly Voted 2 years, 6 months ago
Background color; format by field value because the formatting is based ON AN EXISTING CALCULATION
upvoted 28 times
Shalaleh
2 years ago
If you look you will see for example for a RANGE of numbers they use green. but Field value is for SPECIFIC value not a range.
upvoted 4 times
...
Fer079
2 years, 6 months ago
Background color Rules the existing calculation refers to the measure "% Growth to Last Year" and not about an extra column with the color name
upvoted 87 times
RichardOgoma
2 years, 6 months ago
From my experience, you can format with a measure. In fact the measure can be an if statement with a hex code to manipulate the color on the visual based on another field.
upvoted 2 times
Fer079
2 years, 6 months ago
Exactly, here what we have to calculate is the color based on the measure through the rules, because it does not say anything regarding having a column (or as you say "field") informing about the color
upvoted 6 times
...
...
...
PCCCCCC
2 years, 4 months ago
Bg color and should be based on Rules, we cannot add a measure in Field Value section.
upvoted 9 times
Deepak_098
2 years, 4 months ago
We can add a measure in field value
upvoted 3 times
...
...
...
pisanoagus
Highly Voted 2 years, 2 months ago
Tested -- Background Color / Rules (You can't add a measure for the 'Field Value' option)
upvoted 17 times
...
jaume
Most Recent 4 months, 4 weeks ago
Background color I think is clear for the first part of the question Second answer should be "Rules" where you can set the thresholds to apply different colors. The "Field Value" option is similar to "Rules" but it's required a table returning the colors to be used (the field values) as color names or their hex code. Also a calculations could be used with "Field vlaues" but, again, this calculation should return the values to be used being color names or their hex code
upvoted 2 times
...
rcaliandro
8 months ago
The answer is correct: Background color, rules
upvoted 1 times
...
Ron256
10 months ago
I did my exam on 6/15/2024. Score: 850 This question was on the exam. Please go through the all the set of questions at least twice. Good luck.
upvoted 12 times
...
JOJ990
1 year, 8 months ago
Hi guys, wanna ask those who'r passed the pl-300 exam did they study pages after 22, cause its not free ? should we pay for pages 1-22 are enough pls any recommendation ?
upvoted 2 times
...
miro26
1 year, 8 months ago
Background color Rules
upvoted 3 times
...
MoxieTT
1 year, 9 months ago
Fairly sure this was on the exam
upvoted 2 times
...
prikha16
1 year, 10 months ago
Why cant we use Color scale?- Background color and color scale
upvoted 1 times
akBeater
1 year, 4 months ago
I think because that would not result in 3 colors like in the picture, instead a whole scale of colors. So a ligher and darker green, yellow and red for each different value
upvoted 1 times
...
...
Shalaleh
1 year, 11 months ago
Background Color and rules.
upvoted 3 times
...
RazaTheLegend
2 years ago
Just for clarification, Background and rules seems like a correct answer. However, you CAN add a measure in Field which specifies colors based on hex codes. Those saying you cannot use a measure in Fields are completely wrong.
upvoted 3 times
...
zakikhurshid
2 years, 1 month ago
Just for clarification, Background and rules seems like a correct answer. However, you CAN add a measure in Field which specifies colors based on hex codes. Those saying you cannot use a measure in Fields are completely wrong. You just need to change the measure to TEXT rather than keeping it in Numerical format. Try it and let me know.
upvoted 3 times
...
jsking
2 years, 3 months ago
Background Rules I have done this many times than I can count lol
upvoted 5 times
...
PsgFe
2 years, 3 months ago
calculate background color based on a rule using measurement. correct
upvoted 2 times
...
csillag
2 years, 4 months ago
Background color, format by rules is the correct answer
upvoted 3 times
...
Patrick666
2 years, 4 months ago
Background color Rules
upvoted 3 times
...
lcamp
2 years, 4 months ago
Background Color and Rules - is the correct answer.
upvoted 4 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago