Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 13 discussion

Actual exam question from Microsoft's PL-300

Question #: 13
Topic #: 3

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

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

Submit Cancel

RichardOgoma

Highly Voted 2 years, 9 months ago

Background color; format by field value because the formatting is based ON AN EXISTING CALCULATION

upvoted 29 times

Shalaleh

2 years, 2 months 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, 9 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, 8 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, 8 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, 7 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, 6 months ago

We can add a measure in field value

upvoted 3 times

...

pisanoagus

Highly Voted 2 years, 4 months ago

Tested -- Background Color / Rules (You can't add a measure for the 'Field Value' option)

upvoted 17 times

...

jaume

Most Recent 7 months, 1 week 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

10 months, 1 week ago

The answer is correct: Background color, rules

upvoted 1 times

...

Ron256

1 year 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, 11 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, 11 months ago

Background color Rules

upvoted 3 times

...

MoxieTT

1 year, 11 months ago

Fairly sure this was on the exam

upvoted 2 times

...

prikha16

2 years ago

Why cant we use Color scale?- Background color and color scale

upvoted 1 times

akBeater

1 year, 6 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

2 years, 1 month ago

Background Color and rules.

upvoted 3 times

...

RazaTheLegend

2 years, 2 months ago

upvoted 3 times

...

zakikhurshid

2 years, 4 months 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

...