Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Conditional formatting when column value is greater than a measure

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

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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