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! Get ahead of the game and start preparing now! Learn more
Hi There.
I have a table that i wish to display the row number no matter how it is sliced or filtered within the table
This is my table. I want the user to be able to filter from low to high / high to low on either of the columns but the row number orders from 1 to X
Any suggestions on syntax for an expression. This isnt my strong point so please let me know if I need to provide more info
@LDC20 , I do not think is an out of box solution for that. You have use Rank of that on some measure.
There is an idea for that. Vote for that:https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |