Forum Discussion
Dynamic row number in PowerBi table
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
5 Replies
I can't see how this can work, given the requirement to change the sort order and still have a row number.
I think this will solve my problems, I'll try. Thank you :)
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.
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.
