Forum Discussion
Conditional formatting in power bi
Hi Everyone, I have a requriment where i have to display the values of a column in red, yellow and green color based on the conditon given below: Display the following colors for efficiency % ...
Hi Anonymous,
The rule mode conditional formatting may not work properly when handling the aggregate values of the value field.
For this scenario, you can consider using expression-based conditional formatting:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
You only need to write a measure formula to extract and summary the current value field value and use it as often in the if statement to return color codes.
formula = VAR currValue = SUM ( Table[Amount] ) RETURN IF ( currValue > 0.85, "Green", IF ( currValue >= 0.8, "Yellow", "Red" ) )Regards,
Xiaoxin Sheng
JorgePinho
Solution Sage
Solution SageHello Anonymous !
I prefer to do conditional formatting with a measure.
I would do it like this:
1. Create a DAX Measure
SWITCH(
TRUE(),
table[column] < 0.8, "Red"
table[column] >= 0.8 && table[column] < 0.85, "Yellow",
table[column] > 0.85, "Green",
"White")Note: you can put a specific colour code instead of writing down the name.
2. Apply conditional formatting based on a field value and select the measure