Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |