Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |