Forum Discussion
Conditional formatting not working with SWICH
Hi all,
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?
Anonymous , 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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
3 Replies
Anonymous , 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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values