PL-300 · Question #86
You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements: - All values must be set to two decimal places. -
The correct answer is B. Configure the measure to use a custom format. C. For the visual, apply conditional formatting to the font color.. To display a measure with two decimal places and negative values in red parentheses, apply a custom format to the measure and use conditional formatting for the font color in the visual.
Question
You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements:
- All values must be set to two decimal places.
- All negative values must be displayed in red font and parentheses.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AFor the visual, apply conditional formatting to the background color.
- BConfigure the measure to use a custom format.
- CFor the visual, apply conditional formatting to the font color.
- DFor the visual, set Value decimal places to 2.
How the community answered
(41 responses)- A17% (7)
- B73% (30)
- D10% (4)
Why each option
To display a measure with two decimal places and negative values in red parentheses, apply a custom format to the measure and use conditional formatting for the font color in the visual.
Applying conditional formatting to the background color would change the cell's background, not the font color, and does not address the parentheses or decimal places for negative values.
To ensure all values in a measure are displayed with two decimal places and negative values are shown in parentheses, configure a custom format string for the measure itself (e.g., `#,##0.00;(#,##0.00)`). This custom format applies consistently wherever the measure is used.
To display negative values specifically in red font, you must apply conditional formatting to the font color of the measure within the visual. Conditional formatting allows you to set rules, such as 'if value is less than 0, then font color is red', which overrides the default formatting for specific conditions.
Setting 'Value decimal places to 2' for the visual only handles decimal places uniformly and does not address displaying negative values in parentheses or applying red font specifically to negative numbers.
Concept tested: Custom number formatting for measures and conditional formatting in visuals
Source: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-elements
Topics
Community Discussion
No community discussion yet for this question.