Forum Discussion
Anonymous
3 years agoNot applicable
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-msftCommunity Support
Hi Anonymous ,
Pls share your pbix file ,remember to remove confidential data.
Best Regards
Lucien
- madison13gRegular 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.