This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. 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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |