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
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