Conditional formatting when column value is greater than a measure

[Anonymous]

Hi all,

I have a chart in my dataset like so:

I want to highlight any time the WIP[Count] value (which is a column) is greater than WIP[UNPL] (which is a measure).

Any ideas on how to do this? Using a simple IF statement with > isn't working for me...

Thanks,

Nick

[Anonymous]

Hi @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) We can create a measure. 

Measure = IF(MAX('WIP'[Count])> [UNPL],"red","green")

(3) Setting the Conditional Format and then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Thanks - that didn't quite work. 

Basically on the three charts in the file (download here), I'm looking to create a red dot any time the value falls outside of the dashed orange bars