Display an Application Dependency Matrix

[mgm]

Hi,

I have the following Excel Matrix table;

It is basically a list of apps down the left hand side, then along the top the associated Modules which each App depends on. So for instance App1 will be dependant on Module2, Module4 and Module5. Quite straight forward.

What I'd like to do is display the matrix something like that below;

So a table on the left and when you click on a particular app (e.g App1) it brings up the dependancy relationship on the right. Only thing is I have no idea how to do this. I have worked with Pie Chart Trees and even looked into relationships, but since I am working from one Excel table I am unable to do this.

Any help appreciated.

Thanks

[PhilipTreacy · Accepted solution]

Hi @mgm 

Download sample PBIX with the following examples.

You need to unpivot the Module columns so you get this

You can then use various visuals to analyze.  This example uses a table, a matrix, a treemap and a decomposition tree.  I've overlayed a card on the decomp tree to show thje name of the selected app.

Regards

Phil