Forum Discussion

mgm's avatar
mgm
New Member
4 years ago
Solved

Display an Application Dependency Matrix

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

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    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

     

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    4 years ago

    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