Forum Discussion
How do I hide duplicate leaves in a hierarchy matrix
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.
2 Replies
v-danhe-msftMicrosoft Employee
Hi janeAlice ,
What is your desired result? Could you have tried use multiple columns as rows and use the drill function:
Regards,
Daniel He
- 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