Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi I need some help please.
I am trying to rank my Category in Power BI to display the ranking based on financial YTD.
I currently have a measure of Financial YTD as:
Category | Financial YTD | Rank |
Bread | £1,193,190.15 | 1 |
Fish | £800,774.67 | 2 |
Rice | £262,978.34 | 3 |
Chicken | £222,767.08 | 4 |
Orange | £148,020.17 | 5 |
Water | £114,348.15 | 6 |
Spinach | £97,020.19 | 7 |
Kettle | £94,938.33 | 8 |
Milk | £89,659.71 | 9 |
Cheese | £71,610.05 | 10 |
I have tried using the measure:
It only provides me with the number 1 instead of desc columns.
Greatly appreciated.
Chris
Solved! Go to Solution.
@Chris2B , That measure you have any other not summarized column in visual other than Category[Category]
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s
Hi @Chris2B ,
I think Category should be a dim table which is related to your data table. I suggest you to use [Category] column from data table instead of from Category dimtable.
Measure:
RankingTable =
RANKX (
ALLSELECTED('Table'[Category]),
[Financial YTD]
)
Data model:
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rico, sorry when I tried this solution, it still gave me 1 all the way but I have now found the solution :).
@Chris2B , That measure you have any other not summarized column in visual other than Category[Category]
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s
Thanks for this, it really helped!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
120 | |
71 | |
71 | |
57 | |
49 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |