topic Conditional formatting issue in DAX Commands and Tips

Conditional formatting issue

Mous007 — Wed, 25 Nov 2020 13:20:49 GMT

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

Re: Conditional formatting issue

amitchandak — Wed, 25 Nov 2020 14:11:26 GMT

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

Re: Conditional formatting issue

Fowmy — Wed, 25 Nov 2020 14:25:20 GMT

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