Add row number to table power BI

[DenisStyrt]

Hi, I just want that in any table that I display in Power BI all the rows will have a serial number, By clicking any Slicer or anything else the numbers will show values from 1...... till the end of the table. The number should not be connected to anything, it's only a visual helper(like row numbers in Excel)

Sounds to me like something basic, any Idea how?

[v-xicai · Accepted solution]

Hi @DenisStyrt ,

Currently, you may add Index column in Query Editor, select on query, go to Add Column -> Index Column, choose option "From 1". In this way, there will be an index for the table, while this index column will be filtered by the slicer visual or interaction with other visuals, and it won't show values from 1...... till the end of the table automatically.

While your demand is a good idea, there is an idea about this issue, please vote it up, Add a row count to tables, and you can add your comments there to improve Power BI and make this feature coming sooner.

Best Regards,

Amy 

Community Support Team _ Amy

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

[amitchandak]

@DenisStyrt , check

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448

[vanessafvg]

are you importing the data in? if so add an index column in power query

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query#:~:text=If%20you%....