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.