cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

1 ACCEPTED SOLUTION
Community Support

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,

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

7 REPLIES 7
Community Support

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,

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

Frequent Visitor

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

Resolver III

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

Frequent Visitor

I have this in the column Q 😕

Resolver III

Sorry, I meant in the Column z

Resolver III

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

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

Resolver III