Forum Discussion

Twinkle's avatar
Twinkle
Frequent Visitor
9 years ago

Conditional formatting in Matrix for a range of values

Hi,

 

Any one could help on this:

 

I need color coding in matrix with values >=60 as Green and <60 as Red.
I am getting fixed colors for fixed number instead of a range of values.
Please help!

 

Thx

Need Help
Tips and Tricks

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi Twinkle,

     

    It is available to set conditional colors for a range of values in Matrix. You can turn on conditional formatting by opening the field well menu for the measure and selecting Conditional formattin. Please refer to:

    Matrix conditional formatting

     

    Best regards,
    Yuliana Gu

    • Twinkle's avatar
      Twinkle
      Frequent Visitor
      9 years ago

      Hi @v-yulgu-msft,

       

      Thanks for you reply.

       

      I am trying the same thing that you had mentioned, but getting conditional formatting for fixed values, instead for a range. Like I want Green color for Values >=50 and Red for <50.

       

       

      Thanks,

      Twinkle

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi Twinkle,

         

        As is shown from above schreenshot, currently, the conditional formatting only applies to fixed values. The features in Power BI will be more user frendly in the future. Appreciate for your feedback and ideas.

         

        Regards,
        Yuliana Gu