Forum Discussion
adam_macs
Helper I
Helper IBackground colour - Conditional Formatting
Hi, i have a measure that tracks sales against a target and i would like the background color to change to: green if greater than the target red if less than the target amber if within 5% of the ...
Hi,
if you have static values to define the conditional formatting colors then you can use GUI like your screenshot but if you want to compare two different measures or values then you need to use measure and use that measure on the conditional formatting.
Thanks
Hari
Hariharan_R
Solution Sage
Solution SageHi,
if you have static values to define the conditional formatting colors then you can use GUI like your screenshot but if you want to compare two different measures or values then you need to use measure and use that measure on the conditional formatting.
Thanks
Hari