Forum Discussion
forbi
3 years agoFrequent Visitor
Conditional formatting for a single column (visual matrix)
I have a matrix visual and I want to apply conditional formatting to color the measure_2 column based on the value of measure_1. If measure_1 > Measure_2 then color column measure_2 But I don't fin...
- 3 years ago
Hi forbi ,
This is my test table:
The measures I created:
Measure_1 = SUM('Table'[Value]) Measure_2 = CALCULATE(MIN('Table'[Value]),ALL('Table')) Color = IF([Measure_1] > [Measure_2], "yellow")Conditional formatting:
Result:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.