Forum Discussion
Solved
Conditional formatting issue
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] >= -...
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
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 š