cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Return top 5 items instead of all items with top 5 values in table

Dear Team,

 

Could you please help me with the following issue.

 

I have risks list. Each risk in the list has its score. I need to create a table which will reflect 5 top items based on score. I tried to use Top N filter in Power BI, but it returns 5 top values, which are repeated. But I need it to return 5 top items.

For Example, based on list below I need to retur 6  lines Risks from 09 to 14 (6th line have to be returned too as it is equal to value for 5th item).

 

Risk01        1

Risk02        1

Risk03        2

Risk04        2

Risk05        3

Risk06        3

Risk07        4

Risk08        4

Risk09        5

Risk10        5

Risk11        6

Risk12        6

Risk13        7

Risk14        7

 

Can you please help me with the issue please.

I am not attaching the orignal file as it is huge in volume.

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!