Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Conditional formatting: mix gradient with rule

Hi,

 

I am replacing Tableau reports with PowerBI reports and I am having some trouble with some conditional formatting of background colours...

I need to make a gradient formatting that should be overruled by a rule based formatting. In the screen shot:

  • In row 3, if the value is above 5, the backgound should be red, else a gradient over blue
  • In row 4, if the value is lower that 98% it should be red, else a gradient over blue

Any suggestion on how this can be achieved? I have tried to make a indirect rule to achieve the rule based colour: set red as the standard background and only let the gradient cover the value range up to 5/above 98% but it doesn´t seems to be possible. 

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    Hi Anonymous ,

    Pls share your pbix file ,remember to remove confidential data.

     

     

    Best Regards

    Lucien

  • madison13g's avatar
    madison13g
    Regular Visitor

    Were you able to figure out how to mix gradient and rules in a conditional formatting? I am trying to figure out the same thing.