Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
I am facing issue with numbering rows in a matrix.
I do have a matrix vizualization which has a 4 level of information, data are dynamically changing per client.
What i want to do is to add a running row number, to be able to split the matrix into pages (e.g want to show first 10 rows in a 1st page, rows 10-20 in the 2nd page, 20-30 in a 3rd page, and so on).
Unfortunately i am struggling with having a proper number sequence in a matrix. I was able to achieve this in a table vizualization but it does not meet my requirements unfortunately.
I was able to achieve this with a table:
whereas in matrix numbers are messed-up, not visible in all lvls, sometimes duplicated
what ideally i want to achieve is a running row number, which will be showing number of rows in a vizualization regardless of hirerachy split/ values similar to what we do have in an excel:
Hi @lbendlin , thank you for the effort, much appreciate!
unfortunateluy this solution does not work for me for two reasons:
1- some of the hirerachy elemnts are same accross branches;
2- if i select client 7777 the row rank is not starting with 1,2,3.... but is starts with 14,15,16....
i will be looking for som eother solutions:)
1 - this is where it is important for your to provide sample data that fully covers the issue. I have a couple ideas how to disambiguate that.
2 - can be fixed by using ALLSELECTED() instead of ALL()
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Hi @lbendlin ,
Thanks for coming back to me. I have prepared very simple sample PBI file.
What i want to achieve with this is to have an additional column next to value (or somewhere esle..) which will give some kind of index for currently vizible rows.
It means that it needs to number visible rows dynamically, after all filters are implemented.
I am a ble to achieve this is the table format, but unfrotunatelly struggling with having that index column in the matrix with the hirerarchy level.
Hope now it is more clear.
Please find the data and some screenshots below:
Client ID | Lvl1 | lvl2 | lvl3 | Value |
123 | AAAA | abababa | wyx | 123 |
123 | AAAA | abababa | xyz | 999 |
123 | AAAA | abababa | xyz | 14 |
123 | AAAA | cdcdcdc | wwww | 1000 |
123 | AAAA | cdcdcdc | rrrrrr | 46 |
123 | AAAA | cdcdcdc | yyyyy | 18 |
123 | BBBB | vvvv | nynyny | 13 |
123 | BBBB | nnnnn | mjmjm | 13 |
123 | BBBB | nnnnn | mjmjm | 16 |
7777 | CCCC | adadad | tttt | 345 |
7777 | CCCC | adadad | tttt | 456 |
7777 | CCCC | adadad | yhyhy | 467 |
7777 | CCCC | adadad | yhyhy | 67 |
7777 | CCCC | ffff | uuuu | 99 |
7777 | CCCC | ffff | uuuu | 98 |
7777 | CCCC | ffff | uuuu | 65 |
7777 | DDDD | zzzz | Oooo | 56 |
7777 | DDDD | zzzz | llllll | 56 |
7777 | DDDD | zzzz | xxxxx | 66 |
7777 | DDDD | ccccc | bgbgbgb | 56 |
Index column scenarios:
Client 123:
Client 7777
multiple selections:
Thanks in advance for any tips 🙂
My first reaction was "Whoa, this is far outside the design envelope for Power BI!" But after thinking about it for a while I think this may even be possible. Here is the first step:
Next step would be to count the unique values of Lvl1 and Lvl2 to add to the ROWNUMBER tally.
This gets us a little closer but the upper levels are still incorrect.
Now onto figuring out where we are in the matrix
And here it is in all its fragile beauty
This works only if each element of the hierarchy is unique across all branches.
User | Count |
---|---|
85 | |
84 | |
68 | |
65 | |
56 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |