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

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yadongf-msft's avatar
    v-yadongf-msft
    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.

7 Replies

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

  • Uspace87's avatar
    Uspace87
    Resolver III
    3 years ago

    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's avatar
      Uspace87
      Resolver III
      3 years ago

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