Filter for entire "chain" in network/sankey chart - not just source/target

[Anonymous]

I'm trying to visualise the structure of users > security groups > apps < workspaces < reports for ease of administration.

So far I have tried with the Network Navigator and the Sankey chart. My primary issue is that I only get Source and Target when I apply a filter, due to the datamodel (source/target). 

What I want is for example to select a security group on a list and then display all users in that group AND connected apps AND their connected workspaces AND their connected reports: the entire connection chain so to speak. 

Is that possible and any good ideas? Thanks.

My dataset is organized in Source and Target columns as follows:

Source                        Target

--------                        -------------------

User1                           Security group1

Security group 1          App1

Report1                       Workspace1

Workspace1                App1

[stretcharm · Accepted solution]

Maybe the PATH and PATHCONTAINS DAX functions will help

here is a video explaining their use.

https://www.youtube.com/watch?v=EzfLJFEKV8I

[Anonymous]

Thanks stretcharm. That looks  very relevant AND, sadly, complicated. 

This link seems to break it down well: https://www.daxpatterns.com/parent-child-hierarchies/

I will look into it.

[v-yulgu-msft]

Hi @Anonymous,

Thanks for your sharing. If you have resolved your problem through above link, would you please accept it as a valid solution so that more users can benefit from it?

Regards,

Yuliana Gu