Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Porkey
Regular Visitor

2 Matrix 1 data set, 1 matrix changes with the other, how to stop this

Hi 

 

I have 2 matrix running from the same table

Porkey_1-1647610946854.png

when i select a ?Cell on either matrix it filters the other as below

 

Porkey_0-1647610869856.png

How do i stop this so it only effects the matrix im selecting on?

 

I think my problem is terminology when searching for an answer.

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Select the top visual, go to Format, turn on 'Edit Interactions' and set the bottom table to not be filtered.

jdbuchanan71_0-1647611661820.png

Then do it the other way.  Select the bottom table and set the top to not be filtered.

 

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

Select the top visual, go to Format, turn on 'Edit Interactions' and set the bottom table to not be filtered.

jdbuchanan71_0-1647611661820.png

Then do it the other way.  Select the bottom table and set the top to not be filtered.

 

Perfect thank you very much

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.