Running row number in a matrix hierarchy

[Kopek]

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:

[Kopek]

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:)

[lbendlin]

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()

[lbendlin]

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...

[Kopek]

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 🙂

[lbendlin]

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.