Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |