Forum Discussion

forbi's avatar
forbi
Frequent Visitor
3 years ago
Solved

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...
  • v-yadongf-msft's avatar
    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.