Forum Discussion
Background 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 target
Is it possible to do this within conditional formatting box or does a new measure have to created? I have no idea where to start by applying this logic to the conditional formatting.
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
1 Reply
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