cancel
Showing results for 
Search instead for 
Did you mean: 

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