Forum Discussion
NZ0090
3 years agoFrequent Visitor
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
- amitchandak
Super User
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