Dynamic row number in PowerBi table

[mikolaj]

Hello,

I have few tables with  sales values but with different number of rows. In each table i want to have first column with ordinal number (1, 2, 3, ..., n) wich will be immune for any type of sorting, but will change whe filtering rows. Any ideas hot to do it?, like on the screen below:

Mikołaj

[rajulshah · Accepted solution]

Hello @mikolaj,

You can try giving row number by giving rank to them. You can give rank according to sales value or customer name.

I may be assuming something wrong but I guess the following is what you need.

Let me know this is not what you want.

Regards.

[mikolaj]

I think this will solve my problems, I'll try. Thank you 🙂

[MattAllington]

I can't see how this can work, given the requirement to change the sort order and still have a row number.

[MattAllington]

May I ask why?  Is it just so you can refer to line numbers for commentary purposes?  I don’t think you can do it in a standard visual. A long shot might be a custom visual. 

[mikolaj]

Client wanted this solutions. There's hundreds of rows in tables and he doesn't want to count manually to see on which positions is seller or something like this after sorting (maybe I shoul call it Rank or something to be more precise). 

Custom visual are undesirable, it's going to be PowerBi embedded and it has to work flawlessly.