Network Dependency Analaysis

[ghdunn]

I am brainstorming a way of showing milestones dependencies in a set of projects.

The simple example is:

Program Project Milestone

A,W,W1

A,W,W2

A,X,X1

A,X,X2

B,Y,Y1

B,Y,Y2

B,Z,Z1

B,Z,Z2

I would like to visualise in a network like this:

then..ideally...if i selected anything connected with the first program (A) then i would see:

I then want to extend it to visualise a set of Dependenicies, so I can do some impact analysis.  If i select ANY kind of object...what are all the objects connected with that.  Does anyone have any experience with that or suggestions.  I have tried 'network' in the marketplace but can't get anything working quite right.

[v-yingjl · Accepted solution]

Hi @ghdunn ,

Based on my research, you can try 'Pie Charts Tree' and 'treeviz' custom visual in appsource.

Best Regards,
Yingjie Li

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

[Greg_Deckler]

@ghdunn - Actually, have you tried the built-in Decomposition Tree visualization?

Also, in the market search for "Tree", the first one looks right on the money.

[amitchandak]

@ghdunn , refer if this can help

https://www.sqlservercentral.com/blogs/power-bi-with-different-network-visualizations

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381419?tab=Overview

https://www.mssqltips.com/sqlservertip/5208/graph-analysis-using-force-directed-graphs-in-power-bi-d...