Conditional formatting: mix gradient with rule

[Anonymous]

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. 

[madison13g]

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.

[v-luwang-msft]

Hi @Anonymous ，

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

Best Regards

Lucien