How to combine and show 2 diffrent Hierarcy in 1 Visual in Power Bi

[Anonymous]

I have 2 visual in my power bi like this one.
1.Visual Martix 1

2.Visual Matrix 2

and i want to make a visual like this (see the picture).
so when i click [ICON-0029 ...........] it will show 2 step (Step 1 and Step 2) and can show the data of it.
Is that possible with power bi to make visual like this??

BR,
Faishal Abdillah

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

Hi,

[v-xicai]

Hi @Anonymous ,

The Matrix visual will show content based on the hierarchy of your table field. If you need the step 1 and Step 2 under the same [ICON-0029 ...........] , you may change your table to make the [ICON-0029 ...........] as the parent hierarchy of Step 1 and Step 2. Otherwise, it is unavailable to get your desired output .

As a workaround, you may create column like DAX below, then put the new column1 into Rows box of Matrix visual to as parent hierarchy .

Column1= IF(FIND("Recovery PMO - Indonesia Power",Table1[Origin Column],1,0)>0,"[ICON-0029] Recovery PMO - Indonesia Power", Table1[Origin Column])

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.