Conditional formatting not working with SWICH

[BaronSdG]

Hi all,

I have created the following switch to convert letters into numbers, thinking this would allow me to apply a conditional formatting to the first column by values without any issues. Problem is, the formatting is not working.

This is the formula I use to convert letters into numbers and it is working as  intended as you can see from the pic

isStatus_Color_Background_BetaOrPlanned = SWITCH(components[status], "b", 2,"s", 1, "p",0 )

From the table above, you can see the first column is colored orange, but it should be white.

Here below is the conditional formatting that I have set up. I have also tried changing the summarization to max and other parameters without success.

Any help?

[amitchandak · Accepted solution]

@BaronSdG , create measure like and try conditional formatting with field value option

isStatus_Color_Background_BetaOrPlanned = SWITCH(max(components[status]),

"b", "red"

,"s", "green"

, "p","Blue" )

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

[BaronSdG]

Also, why do I need to use MAX in the formula?

[BaronSdG]

Thanks!

I thing to clarify, the measure must be in the table with the filtering letters, otherwise for some reason it doesn't work (the table in the picture I posted was with the actual data), otherwise it doesn't work