Forum Discussion
visualising multi-tier network (Supply Chain)
Is there any way to create something (at least VERY remotely) similar to this :
or this:
to show relationships between suppliers to visualize a supply chain?
The example is from https://knowledgebase.prewave.com/en/knowledge/tier-n-suppliers,
So example data would look like this:
| from | to |
| 2 SUP | 1 SUP |
| 3 SUP | 1 SUP |
| 4 SUP | 1 SUP |
| 5 SUP | 2 SUP |
| 3 SUP | 2 SUP |
| 15 SUP | 2 SUP |
| 16 SUP | 15 SUP |
| 16 SUP | 1 SUP |
and then the expected output would be:
and additionally - with hundreds and thousands of "nodes", it would "expand" the area of the whole report so I could scroll it, and when I click or filter one "node", everything that is directly or indirectly connected to it, gets highlighted or filtered
I've tried the decomposition tree, a few custom visualisations for visualizing networks (Force Graph, Network Navigator) , a Sankey Diagram and some python stuff, but i can't get anywhere near any useful results. This is probably the closest I got:
but it doesn't satisfy the two requirements above (expanding the area to fit much more data and highlighting/filtering all connections to one node).
Doing it in PBI I feel like I'm trying to use a hammer to sweep the floor, but I'm still hoping that there is a way somehow, I'm even trying to think outside of the box and ignore all these requirements i mentioned above, just answer the question "how to visualize supplier network in PBI?" and I'm lost. Help please 🙂
1 Reply
- Ritaf1983Super User
Hi welbert
I would try these visualizations:Video guide for treeviz :
https://www.youtube.com/watch?v=24pbq3ytCkc&t=184sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly