Forum Discussion

mikolaj's avatar
mikolaj
Regular Visitor
8 years ago
Solved

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 sor...
Need Help
  • rajulshah's avatar
    rajulshah
    8 years ago

    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.

MattAllington's avatar
MattAllington
Community Champion
8 years ago

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's avatar
mikolaj
Regular Visitor
8 years ago

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.