How to add different filters two visualizations on same page

[AmandaZeee12]

I would like to create a hierarchy of filtering where if I select a clinic, the metrics filter for only that clinic in the KPI visuals, but displays the all the clinics within that cohort in the data matrix. Right now, if I click on a clinic it only shows that clinics data in the matrix. What is the simplest way do this?

Let me know if any other information is needed and thanks for your help!

Current State:

Ideal State: 

[lbendlin · Accepted solution]

but displays the all the clinics within that cohort 

That is a "Filtering Up"  pattern.  Use REMOVEFILTERS or disconnected tables.

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar question in the attached file.  Please review it and adapt it to your dataset.

[Anonymous · Accepted solution]

Hi @AmandaZeee12 ,

According to your statement, I think you want to remove the impact between specific visualizations in your report.

I think you can select the slicer and choose None in the below visual and then when you click on the slicer the below visual will keep showing all data without being impacted.

For reference:

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar question in the attached file.  Please review it and adapt it to your dataset.

[lbendlin · Accepted solution]

but displays the all the clinics within that cohort 

That is a "Filtering Up"  pattern.  Use REMOVEFILTERS or disconnected tables.