Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ability to filter downstream dependancies

Hi

 

I have a table that shows project dependancies. The requirement is to be able to identify and visualize the downstream dependancies for any selected Node.

 

 

 

Filtering (e.g. on Project D) unfortunately will only show one level down (i.e. ProjectC) and the requirement is to show all downstream dependancies (a,b and c) by way of a network diagram, table or gantt. I thought the PATH and related functions could assist, however see that they only work for natural hierarchies.

 

Any suggestions and advice would be much appreciated

 

Thanks Doug

 

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

    According to your description above, I wonder if you could use Power Query to generate a table that contains all the related rows.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Sam, appreciated. I am not sure how to go about it, but will consider it

      Regards

      Doug