Conditional formatting for a single column (visual matrix)

[forbi]

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 find this option.
Thanks for help

[v-yadongf-msft · Accepted solution]

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.

[forbi]

thank you Uspace87 
But it colored my whole column, weird !

[Uspace87]

Because in your example all the values of Measure 1 are bigger than measure 2

[forbi]

I have this in the column Q 😕

[Uspace87]

Sorry, I meant in the Column z

[Uspace87]

@forbi 

1) Create a Measure = If ( Measure 1>Measure 2, 1, 0)

2) you use the conditional formatting on the measure you want to format 

[Uspace87]