Forum Discussion

PowerBIFan5's avatar
PowerBIFan5
Frequent Visitor
1 year ago
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 ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

I may be able to generate a table (not different card visuals).  I would like to try.  Share some data and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

PowerBIFan5's avatar
PowerBIFan5
Frequent Visitor
1 year ago

Thanks Ashish, I ended up solving the issue using a duplicate fact table so I am all set now.