Forum Discussion

aslan's avatar
aslan
Icon for Helper I rankHelper I
9 years ago

Matrix Conditional Formatting

I want to give red color background if total value is greater than 10. And if less than 10 is should be green. But there is no option. Do you know any way?
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi aslan,

As Phil_Seamark posted, I try to reproduce your scenario using the sample matrix.



Right click the value level->select Conditional Formatting.



You will get expected result.

 

If you have other issues, please let me know.

Best Regards,
Angelia

  • aslan's avatar
    aslan
    Icon for Helper I rankHelper I
    9 years ago

    Is it possible to define Number value by variables instead of direct input?

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi aslan,

      Up to now, we are unable to create a variable to control the color.

      Best Regards,
      Angelia

      • denzelg2g's avatar
        denzelg2g
        Icon for Advocate I rankAdvocate I
        9 years ago

        v-huizhn-msft

        When will this be possible? I would also like to see this function! Also, is there a work around atm? A calculation like: value1 minus value2 would give a positive or negative result which you can make condional formatting on (>0 green, <0 red). How can I do this the easiest way when I want to make that calculation on 1 metric but from 2 dimensions. 

        I've made an example of what I want (see photo).

        I want to calculate the difference between my expectation and my target for 1 metric. If I can make this calculation, I can make the conditional formatting, I guess.