Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Team,
I have come across a new requirement on conditional formatting across PowerBI table where in case the KPI>=100%, the cell color should be green while on KPI% being varied from 0 to 99.99%, the gradient of red to yellow should follow.
The best solution which I could think of is to use a measure to identify some intervals from 0-99.99% to classify for different shades of red and yellow while with >100% as green but again this won't be providing a close enought impact to the gradient.
Any other ideas to figure this out? Sample data set as below:
Best Regards,
Arpit
Did you try conditional formatting? Under visualizations pane where you insert the columns in the table select the down arrow - conditional formatting - gradient rules.
From there, enter your rules.
Hi, I need to use both rule and gradient in a single column formatting. These are two seperate options in current PowerBI setup
User | Count |
---|---|
81 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |