Visualizing warehouse and product structure

For me, the confusion is how you have your assembled parts and component parts in the same table for QoH.  This isn't impossible to work with, but I had to create some fake names below (A, A01, A02) to help me seperate the data for visuals.

Screen Shot 1 - Your two raw tables:

Screen shot 2:  You have to define a Relationship very specificically to tell Power BI how to account for the duplcication of data between the two tables.  Part has to link to Com_Part with a 1:Many relationship!  **** This is the key to all other data analysis. ****

Screen Shot 3:  Now you can create a table with Part and Com_Part and Qoh from the 2 different tables and Power BI knows how the 'Relate' to each other:

Screen Shot 4:  With the Quantity Part Assembly value changing sub-part by sub-part my first thought of how to use the data was to look for parts with possibly a HIGH QoH, but because you need X of them to make a Bigger Part, there might be a actionable value to looking at the number of Bigger Parts you "could assemble" with your QOH of Sub-Parts.  

Potential Assembly = SUM(QOH[QoH]) / SUM(Part_Breakdown[Qty_P_Ass])

Screen Shot 5:  Finally trying to look at the bar graphs you requested.  You can 'stack' you Axis now with Part and Com_Part to get drill thru, but I wasnt' able to make it look like I think you had intended.  Play with your values from here and see if you can get anything actionable out of your real data!

Hope this helps,

FOrrest