Forum Discussion
unnijoy
6 years agoPost Prodigy
colour formating
Hi want a measure that can be used for colour formating based on Parameter and target. In our case some are like if the actual is below the target then it show green background and in some case if ac...
- Anonymous6 years ago
When you have clicked on the conditional formatting then you should be able to change the format by to field value and then select your measure as the field like below.
If this works then please mark it as the accepted solution.
Mariusz
6 years agoCommunity Champion
Hi unnijoy
You can create a measure like below.
Colour Formating = INT( [Actuals] >= [Targets] )
And use it for conditional formatting, format by "Rule" as below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.

Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.