Forum Discussion

deanbland's avatar
deanbland
Helper III
5 years ago
Solved

Help with conditional formatting!

HI,    I have a matrix table (shown below) and I am wanting to conditional format the cells within each column in the following way:    - Between -5 and +5, they are highlighted Green - Above +5...
Need Help
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    deanbland 

    Try:

    SWITCH(TRUE(),

    [Your measure] < 0.81, "red",
    [Your measure] > 1.19, "red,

    [Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
    "orange")

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi deanbland ,

 

Are you using 1 measure or multiple measures?Can you share your .pbix file if there's no confidential information inside?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!