Forum Discussion
Adding Row Numbers to a Table
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.
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
2 Replies
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