- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Edit Interactions - cross filtering on visuals
I have various filters that I'm using so that columns appear dynamically in the matrix. Those three filters are from the same field. Versus having a long list of options I was trying to break it up into categories, ie. Geography, Store Details, etc. (Each filter visual is filtered to specific columns only) HOwever when I select one of the columns in one visual the others disappear (which makes sense) but is there a way to avoid this? I tried to do edit interactions, but and turned off filtering on each of the respective visuals.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @jcastr02 ,
Try creating this field as a separate dimension table and splitting it into three fields. Get the slicer value via selectvalue and then use if(max([field])=_s1||max([field])=_s2||max([field])=_s3,1,0), to set this measure value to 1 in the filter.
Please feel free to correct me and provide more information if I have misunderstood you!
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @jcastr02 ,
Try creating this field as a separate dimension table and splitting it into three fields. Get the slicer value via selectvalue and then use if(max([field])=_s1||max([field])=_s2||max([field])=_s3,1,0), to set this measure value to 1 in the filter.
Please feel free to correct me and provide more information if I have misunderstood you!
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@jcastr02 , Hope you have selected the visual one and Switch off the interaction visuals 2 and 3. Each visual is a driver for interaction. So you have select each one and disable the other.
If that has been done, and still now works. If this does not help
Can you share a sample pbix after removing sensitive data.
Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-31-2024 08:26 AM | |||
06-05-2024 08:15 AM | |||
07-09-2024 03:10 AM | |||
09-12-2016 01:53 PM | |||
12-05-2024 04:40 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |