Forum Discussion
Solved
Product Structure and Power BI
Good day all, I'm trying to create a visual to display product structure and some general information on that product. The information is pulled from one master stock on hand report, this report ...
Good day all,
Just wanna give an update to this issue, I have managed to get it resolved, fixing up relationships and creating an index for the BOM data and playing with some of the filters 🙂 all in all good result its what I was looking for.
Once again thank you all for your input as it all did help
Regards
Snowy
Create 2 respective slicers.
Build your BOM structure by creating hierarchy and as Rows/Values of matrix visual.
Format the matrix with option - "Stepped layout" for your desired output layout.
- Hi sir,
Could you give me an example how to do that?
Should by file that holds my BOM be something like this
6611 | 116007/5 | 125111 | 145111 | 150511 | 151378
The idea is when I have the BOM codes as a slicers and I click on 6611 the visual would show the BOM codes and the stock on hand