Forum Discussion

NZ0090's avatar
NZ0090
Frequent Visitor
3 years ago

Add row number in matrix

Hi everyone,

 

I have a matrix that looks like this:

 

How do I add row numbers to the matrix? The matrix can be expanded multiple levels. I've tried some solutions I found on the internet and I couldn't figure out how to make it work and most of the solutions I found are used with tables instead of matrix. 

 

Additional note: 

- I'm using Direct Query

- Matrix can be sorted by either Sales or Qty

 

Any help is appreciated! Thank you

 

1 Reply

  • NZ0090 , As of now you do not have the row number of the serial number , You need have some column at source that can do that

    In table visual, we can use the window to get row number as measure

    Learn Power BI: Window as Rank- why and Why not: https://youtu.be/Pu8y8bd5mb8