Adding Row Numbers to a Table

[tas6959]

What is the easiest way to add row numbers to table.  Indexed table column would not work as the data is being filtered and the table will only will be showing the top 10 items regardless of the filters selected.  Basically I need a column that shows rows one thru ten at all times.

[AlexisOlson · Accepted solution]

It sounds like you want RANK or ROWNUMBER.

[Anonymous · Accepted solution]

Hi @tas6959 

If you want to add dynamic row numbers in table, it cannot implement,  because the data is static, you can't dynamically change the row ID based on the table filter. If you want to dynamically display row IDs, you can consider using the table visual and use  the rankx() function in measure.

You can refer to the following link.

Creating Dynamic Ranking Tables Using RANKX In Power BI | Enterprise DNA

DYNAMIC RANKX BY SLICER SELECTION IN POWER BI - Ruki's Blog (rukiatu.com)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AlexisOlson · Accepted solution]

It sounds like you want RANK or ROWNUMBER.