Forum Discussion

ShmuelM's avatar
ShmuelM
Advocate II
9 years ago
Solved

How to add a Serial Row Number Column in Power BI Table / Matrix visual?

Hi is there a way to do that , just to add the row number that will regenerate every time the table changes? 
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi ShmuelM,

     

    Grabbing in your table just add a measure with the countrows:

     

    Row_Number = 
CALCULATE (
    COUNTROWS(Profit_Table),
    FILTER ( ALLSELECTED ( Profit_Table ), Profit_Table[Position] <= MAX ( Profit_Table[Position]) )
)

    As you can see in the print below it counts the number of rows no matter if you have slicer or not, left table is the full data, right table is influenced by slicer.

     

     

    Please be aware that this measure is influenced by the order of your Position so if you want to order by another column this will give you the row number in a different order also.

     

    Regards,

    MFelix

     

     

Yi's avatar
Yi
Regular Visitor
7 years ago

I have a new challenge in this area. I have a table with Index, City, Street, Value1 and Value2. There are duplicated value in City and Street, but Value1 and Value2 are different. Like

Index   City    Street  Value1  Value2

1           A       123      D1        C1

2           A       123      D2        C2

3           A       456      D3        C3

4           A       456      D4       C4

5           B       131      D5        C5

I use a scatter to see the Value distribution and I also want to use a table to see how many City and Street couples when I change a filter by Value1

I have the problem to show the row number in table, it show like

RowNo  City   Street

2            A       123

4            A        456

5            B        131 

What I want is

RowNo  City  Street

1            A       123

2            A       456

3            B        131

ajohn1's avatar
ajohn1
Advocate I
7 years ago

Microsoft should have just added a on/off for row numbers for tables and matrix. I'm needing help with this exact same question. Has this been answered for you?