Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
103 | |
103 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |