Network Member analysis

[KriswithaK]

Hi all

I'm currently working on a dashboard to help our team better understand how hospitals in our country collaborate.

To give some background, each hospital is part of a certain number of networks, in which they extensively collaborate.

E.g. hospitals collectively buy pharmaceutical drugs as one single purchasing group, treatment of patients with a rare disease is discussed within the same oncology group etc.

I have a complete list of all the networks each hospital is a member of.

I've been trying to create to create something like the below for days now, but unfortunately in vain..

The idea is to have a bar chart on the left that shows the # of patients.

If you select a hospital in that bar chart, all the networks the hospital is part of, should appear in the visual on the right side AND all other hospitals that are part of the same network should pop-up as well.

Taking the below example, if I would select "Hosp B", the figure should tell me that Hosp B is part of...

1. Regional network X
2. Oncology network Y
3. Purchasing group Z

In addition, the visual also shows that Hospitals A-G are part of (at least one) of these three networks.

Furthermore, you also see that Hosp C is a member of all mentioned networks. 

Which would indicate that there is a lot of collaboration going on between hospital B & C.

I've tried to create this in dozens of visuals (Pie Charts Tree, Zoomcharts Network chart, journey chart etc.), but I always run into the same issue. Whenever I select a certain hospital, the visual shows the networks it's part of, but not the other hospitals within these networks.

Is there a way to design the dashboard, so I can filter on a hospital. Allowing me to show all the networks it's part of along with all other member hospitals?

Thanks a million for your help!

[DataInsights · Accepted solution]

@KriswithaK,

This sounds like a similar post I recently solved (link below). The concept is to create a clone of your dimension table and use this cloned table in your visual. Then use DAX (in a measure) to filter per the requirements.

https://community.powerbi.com/t5/Desktop/Filter-Table-by-Column-Values-Associated-with-Selected-Slic... (thread 4)