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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Ragged Multi-Parent Hierarchy.

I am relitively new in the world of data structuring and schemas. I am looking to display a multi-level BOM in it's hierarchal format within a Matrix or Decomposition tree. 


Generally I've been able to acheive this. The shortcomings are dealing with Blanks that show up, and inaccurate sums and quantities. For example, see the data table and how it looks in PowerBI.

My Datasource is Excel. 




I've watched these videos:

They have certainly been insightful and have taught me a lot. However the data structures in these videos are assuming a child does not have multiple parents which, in the case of a multi-level BOM, can very well be the case. The PATH function seems to be the limiting factor as I think it struggles with multi-parents. 

IE, On the Bicycle, there is a front and back wheel assembly. They share the same rim, but have different tires.

Thanks for any insught anyone can provide!


Frequent Visitor

I was speaking with some people and they mentioned making the parts with multiple parents have unique Id: Part + Assembly ID = Unique ID.

Now, I just need to figure out how to display on a matrix visual just the basic sub assy ID's and Part ID's while relying on the Unique ID's in the background. 


Just food for thought

Impactful Individual
Impactful Individual

i see collaped (unexpanded) section in your matrix table, if you dont want to show the expand and collaps option use the stepped layout option in format pane so your matrix will look like the on ein your excel file.


Learn Power BI free:

Power BI : getting started

Dax functions

powerbi Visualisation



Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors