The ordinal number of the lines in the visualization table.

[kairat1976]

Hello!
Help me please!
(Power BI Desktop, Object - Table)
How can I add a field with a sequential row number to the table, which will preserve the order from 1 to "n" when sorting any of the columns.

[kairat1976]

Sorry, not a field, but a column

[kairat1976]

And another question is whether it is possible to customize the table so that it grows vertically when filling the data, and the minimum size is fixed?

[v-robertq-msft]

Hi, @kairat1976 

According to your description, I think the only way to achieve this is using the “Add index column” function in the Power Query editor, you can follow this document:

https://yodalearning.com/tutorials/learn-how-create-index-columns-using-power-query/

What’s more, to ask some questions about tricks in Power BI, I suggest you to go to the desktop forum of this community.

Best Regards,

Community Support Team _Robert Qin

[kairat1976]

Thanks for your feedback, but we are talking about a tulle object in the render. And already on the table you need to put a number that will not react to sorting. Temporarily made as two tables, one with numbers in order, another with data

[v-robertq-msft]

Hi, @kairat1976 

To get a table with numbers in order, you can create a new table using DAX in Power BI:

Table = GENERATESERIES(1,100,1)

However, you can manually create another column to enter data, the columns have to be logical.

If you still have a problem, you should go to the desktop forum of this community. Because this forum is talking about existing issues in Power BI, we discuss Power BI tricks in the desktop forum.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin