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.

       

       

       

       

       

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

        Hi denzelg2g,

        For your requriement, it's unable to achieve in PowerBI desktop now. You can post the request here.

        Best Regards,
        Angelia