Forum Discussion
Conditional Formatting by Percentage for Low Performers
Hopefully, this is an easy one, I am looking to highlight the bottom 25% of the revenue rank. Ranks are subject to change so I cannot place values as the rule.
6 Replies
Anonymous Revenue Rank is a calculated column or a measure? What you have shown in the screenshot, is that not working?
The Rank is using the rankx function.
It seems to be working okay in this example but is not quite right. I have this same conditional formatting on two separate virtual tables. both with rankx and both with the same group of individuals, there are 41 in this month's example. In the picture above, there is 11 highlighted which is 26.8% close but not exact. People's jobs are being scored on this so I want to make it as precise as possible.
in the next example, which is again identical, it's way off, which makes me doubt both conditional formattings. In this example, there are 7/41 highlighted, 17%.
- So...what is the issue??
