Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.        
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous Revenue Rank is a calculated column or a measure? What you have shown in the screenshot, is that not working?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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%. 

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Any thoughts or workarounds? Or anything else I can provide to help?

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        6 years ago

        Anonymous 

         

        You may use the following measure.

        Measure =
IF (
    [Rank]
        > CONVERT ( COUNTROWS ( ALLSELECTED ( 'Table'[Name] ) ) * 0.75, INTEGER ),
    1
)