Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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.
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.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.