Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |