How do I hide duplicate leaves in a hierarchy matrix

[janeAlice]

Hi, I have a table that contains hierarchy data. I want to visualize that in PBI using the matrix visualization with row headers +/- Icon set to "on".  The issue I am having is that when I click the "+" symbols, it drills down, but there are duplicate entries in each leaf. The data is intended this way. I was wondering if there's any way to stop from drilling the + signs down if the next leaf in the tree is a duplicate of the previous.

Here is my raw data:

Business_Unit	l1	l2	l3	l4	l5	info	moreInfo	evenMore	andMore
Unit A	level 1-a	level 2-a	level 3-a	level 4-a	level 5-a	something	something5	something9	something13
Unit B	level 1-b	level 2-b	level 3-b	level 3-b	level 3-b	something2	something6	something10	something14
Unit C	level 1-c	level 2-c	level 2-c	level 2-c	level 2-c	something3	something7	something11	something15
Unit D	level 1-d	level 2-d	level 3-c	level 4-d	level 4-d	something4	something8	something12	something16

Here is what I have in PBI:

As you can see in the above PBI viz, for example, in the 3rd leaf, it goes level 1-c, level 2-c, level 2-c, level 2-c, level 2-c. I needed it to go level 1-c, level 2-c and stop right there and eliminate the ability to + drill down farther.

Any helps is appreciated as this is my first time using PBI. Thanks.

[v-danhe-msft]

Hi @janeAlice ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft]

Hi @janeAlice ,

What is your desired result? Could you have tried use multiple columns as rows and use the drill function:

Regards,

Daniel He