visualising multi-tier network (Supply Chain)

[welbert]

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 🙂

[Ritaf1983]

Hi @welbert 
I would try these visualizations:

Video guide for treeviz :
https://www.youtube.com/watch?v=24pbq3ytCkc&t=184s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly