Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
@KeatonO Revenue Rank is a calculated column or a measure? What you have shown in the screenshot, is that not working?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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%.
Any thoughts or workarounds? Or anything else I can provide to help?
You may use the following measure.
Measure =
IF (
[Rank]
> CONVERT ( COUNTROWS ( ALLSELECTED ( 'Table'[Name] ) ) * 0.75, INTEGER ),
1
)
I don't know if I was using this wrong or what but it's a no-go as well. I appreciate the help though. 🙂
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |