Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

How to create Power BI Matrix with multiple Dimension with Hierarchy?

I want to Create Matrix with Multiple Dimension Hierarchy with Collapse and Expand Functionality as per below snap.

 

Whenever Click on ID then Display ID level Details

harshshah_0-1603110799841.png

Click on Parent Element "1234M01" then need to expand Order Details under this element.

harshshah_1-1603111047740.png

 

Click on OrderNo "980" then need to expand Sub Order Details like (Material,Labor).

 

112.PNG

 

 

 

 

Status: New
Comments
v-lili6-msft
Community Support

hi  @harshshah 

You may have a look this document:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

 

Regards,

Lin