Forum Discussion
Conditional Formatting not behaving as expected
Hi Anonymous ,
I create a simple sample that you could have a try. And you can use any of the values listed in the CSS color spec at https://www.w3.org/TR/css-color-3/ to color your visuals. In my sample, I use text to color it. Please view the sample below.
Conditional formatting = SWITCH ( TRUE (), 'Table'[%] <= 0.05, "Red", 'Table'[%] <= 0.1, "Yellow", "Green" )Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-xuding-msft this is really helpful!
I am struggling as to how to implement it though as I am not measuring against a goal but a % of the Row total in a Matrix so the only field I have is Revenue against millions of rows.
The Matrix looks something like this
| Line of Business | Windows | Doors | Flooring | Total | ||||
| Country | Rev | % | Rev | % | Rev | % | Rev | % |
| UK | 25.1 | 51% | 11.4 | 23% | 13 | 26% | 49.5 | 100% |
| France | 10.6 | 9% | 100.2 | 82% | 11 | 9% | 121.8 | 100% |
| Germany | 30.1 | 44% | 18.9 | 28% | 19.5 | 28% | 68.5 | 100% |
| Total | 65.8 | 27% | 130.5 | 54% | 43.5 | 18% | 239.8 | 100% |
There are sublevels below those in the matrix also going down at least 4 or more levels.
Thanks again for the help!
Hi Anonymous ,
I create a simple sample that you could have a try. And you can use any of the values listed in the CSS color spec at https://www.w3.org/TR/css-color-3/ to color your visuals. In my sample, I use text to color it. Please view the sample below.
Conditional formatting =
SWITCH (
TRUE (),
'Table'[%] <= 0.05, "Red",
'Table'[%] <= 0.1, "Yellow",
"Green"
)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.