Conditional formatting in power bi

[Anonymous]

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.

[Anonymous · Accepted solution]

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]

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