Forum Discussion

welbert's avatar
welbert
New Member
2 years ago

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:

fromto
2 SUP1 SUP
3 SUP1 SUP
4 SUP1 SUP
5 SUP2 SUP
3 SUP2 SUP
15 SUP2 SUP
16 SUP15 SUP
16 SUP1 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 🙂