Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I got a Pivot table that shows the same value as an absolute, as well as a percentage of the row total, see below.
I want to highlight values based on the percentage they represent, so that 0% is always white and 100% is always the other end.
Above, it's formatted based on n, so the highest number (93) is way darker then the two fields above it, even though the percentages are similar.
Any suggestions on how to fix this?
Thanks in advance
Solved! Go to Solution.
Hi @aburmester ,
Try to change your conditional formatting setting like below:
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aburmester ,
Try to change your conditional formatting setting like below:
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |