Visualizing BOM with a tree visual

[Anonymous]

Hello,

I have an issue about displaying the BOM in a tree view.

My data has the following shape : 

Product	ProductComponent
ProductA	Comp1
ProductA	Comp2
ProductB	Comp1
ProductB	Comp3
ProductB	Comp4
Comp3	Comp33
Comp3	Comp34
Comp4	Comp41
Comp4	Comp42

I want to make a tree view of this BOM.

I tried to use the Child/Parent tree (https://ck-corp.github.io/TreePowerBIVisual/) it works very well but the problem is that I have childs with many parents, and that causes a problem in the visual. This visual is made for hierarchy, so child usually have only one parent.

I also tried the Sankey Chart, it works well for the direct childs, but I have many levels depth. 
For example, Product B --> Comp3 --> Comp33 --> .....

Finally I tried the classic decomposition tree of Power Bi, but it doesn't deal with recursive BOM.

How can I handle this case ? 

The goal is to have an expandable tree view with all the BOM.

Thanks for yout help !

[PhilipTreacy]

Hi @Anonymous 

Please explain what you mean by "it doesn'rt deal with recusive BOM".  Show an example of this 'recursion'.

Regards

Phil

[Anonymous]

Hello @PhilipTreacy ,

By recursion I mean that in the same column, I have many level of depth.
I don't have a column for each depth level.

For example : 

Product	ProductComponentLevel1	ProductComponentLevel2	ProductComponentLevel3	ProductComponentLevel4
ProductA	Comp1
ProductA	Comp2	Comp1
ProductB	Comp3	Comp2	Comp0
ProductB	Comp4	Comp1	Comp3	Comp0

Such a representation could be easily used in a tree representation. But instead I have :

Product	Component
ProductA	Comp1
ProductA	Comp2
Comp2	Comp1
ProductB	Comp3
ProductB	Comp4
Comp3	Comp2
Comp3	Comp0
Comp4	Comp1
Comp4	Comp3
Comp4	Comp0