Conditional formatting

[New_worker]

Hey, I am preparing the exam, and here is a question regarding conditional formatting. My answer is C, but I am not sure. Anyone can help? Thank you. 

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?

• A. font color
• B. icons
• C. data bars
• D. background color

[PavanLalwani]

The correct answer is **D. Background color**.

Here's why:
- **Background color** allows you to visually compare values by color-coding them without displaying the numbers, which meets the requirement to hide the numeric values.
- You can assign a **different background color for each distinct value** (from 1 to 20).
- It's a straightforward, low-effort solution in Power BI's conditional formatting options.

While icons or data bars are useful, they don't hide the numeric values, so **background color** fits all the conditions.

[divyed]

Hello @New_worker ,

The correct option is C using Data Bars due to following reason :

• Visually compare the values without having to read the text containing the number.

   One can easily compare value from size/length of the the bar, no need to read text
• Show a different format for each distinct value.

   You can choose different bar colors of your choice and even apply dynamic formatting. Each bar is a distinct     value
• Hide the numeric value of ColumnA.

   You can hide and show labels as per need 
• Minimize development effort.

   Showing data bars removes creating separate charts to answer the same. One chart can have many features

I hope I answered your questions. If you find this usefull, please mark this as solution. Will appreciate Kudos :).

Cheers

[New_worker]

Hi @divyed , 

Thanks for your reply. Could you explain more about this item? How to choose different color for differnt values? 

Show a different format for each distinct value.

   You can choose different bar colors of your choice and even apply dynamic formatting. Each bar is a distinct  value

[divyed]

Hello @New_worker ,

You need a combination of conditional formatting and there is no direct way (I should have written in last comment) .

1. Use conditional formatting to set data bars. Use can choose colors for positive and negative value

2. Use conditional formatting to choose background/font color , this can be done either using

field value or rules.

Alternatively you can create custom bars (using clustered bar chart or similar) and format as per you need.

I hope this helps.

Cheers

[Ritaf1983 · Accepted solution]

Hi @New_worker 
C

The simplest way to compare values without showing the actual numbers (and ideally without using numbers at all) is by comparing rectangles that are stacked one on top of the other, starting from the same point. This way, even children can easily estimate the differences between them.

That's why the correct answer is C. 🙂

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly