PL-300 · Question #425
You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional formatting to meet the…
The correct answer is C. data bars. To visually compare numeric values (1-20), show distinct formats, hide the numbers, and minimize effort, data bars are the ideal conditional formatting choice in Power BI.
Question
You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional formatting to meet the following requirements:
- Visually compare the values without having to read the text
containing the number.
- Show a different format for each distinct value.
- Hide the numeric value of ColumnA.
- Minimize development effort.
Which formatting should you use?
Options
- Afont color
- Bicons
- Cdata bars
- Dbackground color
How the community answered
(21 responses)- A14% (3)
- C76% (16)
- D10% (2)
Why each option
To visually compare numeric values (1-20), show distinct formats, hide the numbers, and minimize effort, data bars are the ideal conditional formatting choice in Power BI.
Font color would require defining 20 distinct colors and would not inherently hide the numeric value or provide a clear visual comparison of magnitude as effectively as data bars.
Icons are typically used for thresholding or categorization and would require complex rules to show a different icon for each of 20 distinct values, making it high effort and potentially visually cluttered.
Data bars visually represent the magnitude of each number within its cell, allowing for quick comparison without reading the text, and Power BI allows hiding the numeric value, showing only the bar, and automatically scales for distinct values with minimal configuration.
Background color would suffer from the same issues as font color, requiring many distinct colors and not inherently hiding the numeric value for magnitude comparison as efficiently as data bars.
Concept tested: Power BI conditional formatting (data bars)
Source: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-elements#data-bars
Community Discussion
No community discussion yet for this question.