Conditional formatting issue

[Mous007]

Hi all,

I have generated the below table with two metrics.

The Quality KPI switch = 

quality KPI switch = SWITCH(TRUE(),

[Quality KPI] < -0.1 , "G" ,

[Quality KPI] <= 0 && [Quality KPI] >= -0.1 , "A" ,

[Quality KPI] < 1 , "R" )

I would like to apply  conditional formatting with three different colors to the quality KPI column using the quality KPI figures

I want to apply the following rules to my formatting

If Quality KPI is between 0 and - 10% --> "A" and "Color1"

If quality KPI is more than - 10% --> "G" and " Color2"

If quality KPI is more than 1% or any positiive value --> "R" and "color2".

I tried to add the colors into the switch function and also tried the conditional formatting but did not manage to get the expected results

Can anyone please help me achieve this or at least guide me on how i can get it done ?

Thanks in advance

[Fowmy]

@Mous007 

May be this way: 

Quality KPI switch = 
SWITCH(
    TRUE(),
    [Quality KPI] < -0.1 , "Green" ,
    [Quality KPI] <= 0 && [Quality KPI] >= -0.1 , "Amber" ,
    [Quality KPI] > 1 , "Red" 
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak · Accepted solution]

@Mous007 , a color measure like given below can used in conditional formatting with field value option

quality KPI color = SWITCH(TRUE(),
[Quality KPI] < -0.1 , "Green" ,
[Quality KPI] <= 0 && [Quality KPI] >= -0.1 , "Yellow" ,
[Quality KPI] < 1 , "Red" )

refer for steps

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values