Forum Discussion
Visualizing BOM with a tree visual
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 !
2 Replies
Hi Anonymous
Please explain what you mean by "it doesn'rt deal with recusive BOM". Show an example of this 'recursion'.
Regards
Phil
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
