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 %
1. If <80 show as red
2 If 80 - 85 show as yellow
3. If >85 show as green
I have tried to do the above using conditional formatting option in powerbi but my result is not proper.( The value in yellow should be green ideally)
The formual i have used in conditional formaating is this:
Can anyone please help me with this.
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
2 Replies
- JorgePinho
Solution Sage
Hello 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 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
