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!...
Need Help
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Microsoft Employee rankMicrosoft 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