Ability to filter downstream dependancies

[DougM]

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

[v-chuncz-msft]

@DougM,

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

[DougM]

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

Regards

Doug