Forum Discussion
christinek
3 years agoFrequent Visitor
conditional formatting
Hi Power BI Community, hoping someone can assist with what I am trying to achieve with conditional formatting on my "Actual productivity" column.
Example data/columns:
Target productivity | 90% of target | Actual productivity |
80% | 72% | 85% |
80% | 72% | 75% |
80% | 72% | 70% |
ie Green = greater than target productivity
Orange = within 90% of traget productivity
Red = below 90% of target productivity
Thanks in advance.
3 Replies
- ryan_mayuSuper User
- christinekFrequent Visitor
Thank you so much ryan_mayu.
Solution is perfect.
Really appreciate your help.
- ryan_mayuSuper User
you are welcome