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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
LDC20
Frequent Visitor

Display Row Number in Table Visual

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

 

power bi help.png

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors