Forum Discussion
Solved
Next Top 5 Ranked
Hello, I am trying to be able to show the next top 5 ranked items based on the item selected in a slicer for the page. For example, if the selected item is ranked 6, I want to be able to show who is ...
Hi PowerBIFan5 ,
As per your earlier post, you need to use the slicer as the basis for your selection, and if you don't want to enter it manually you can use hardcoding to specify the range of rankings you need to display.Top5 = IF( Table_1[Rank] > 6 && Table_1[Rank] <= 11, 1, 0 )Similar to the 6, and 11 here.
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Why not just list all of them in a table with their rank as a column? Let the report user's eyes do the work.
Thank you for the idea. I kept that in mind for a backup but I ended up solving the issue so I could display it as requested.