Forum Discussion
Ranking Multiple columns in a matrix
Hello
I have a matrix that I am trying to show the top 3 Level 2 downtime areas and then show the top 3 reasons (level 3) for that area. I am using TOP N for the first column, from my research it seems that I should be using RANK for the second column but I am lost as to how I do that.
I am a very novice user so any help would be greatly appreciated.
Thanks
Cara
Hi Ashish
Hopefully this works
https://drive.google.com/file/d/1U0DWUxqqb8Spd3OhaYwwyae-TqTf-4Gq/view?usp=sharing
Thanks
Cara
14 Replies
- Ashish_Mathur
Super User
Hi,
What happens when you use Top N for the second column as well? Share the link from where i can download your PBI file.
You can only use TOP N on one column, thats really my main issue.
Hopefully this works for sharing the file......
https://app.powerbi.com/groups/me/dashboards/d8750caa-4718-41f9-8db3-346e5f9df6e7
- Ashish_Mathur
Hi,
I cannot download the file from here.
- Rfranca
Resolver IV
hi,
I understood what you want
it is not necessary to create the TOP N or RANKX creates the columns and their levels and only classifies the values according to the image.
