Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Problem with a simple TOP5

I everyone, 


I am trying to make a simple top 5 on a table. 


So I created a filter "First N" filtering the first 5 rows by Amount Desc.

The table is something like this: 
DATE | STORE | N° Gift card | Amount 

But the filter won't work, I keep getting too much lines, (I clicked on "apply filter"), I tried to do this on visuals in case it was the "table visual" that wasn't compatible with the TOP N filter but it doesn't work either. 


Do you have any ideas why a filter that simple wouldn't work ? 

Thanks a lot guys ! Do not hesitate to contact me if you need more info.

1 REPLY 1
lbendlin
Super User
Super User

Do you have a lot of gift cards with the same amount?  You can add a small random value to the amount in order to break the ties.

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.