Reply
jcastr02
Post Prodigy
Post Prodigy
Partially syndicated - Outbound

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.

 

Screenshot 2023-11-20 093633.png

Screenshot 2024-01-11 144422.png

1 ACCEPTED SOLUTION
v-tianyich-msft
Community Support
Community Support

Syndicated - Outbound

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.

View solution in original post

2 REPLIES 2
v-tianyich-msft
Community Support
Community Support

Syndicated - Outbound

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.

amitchandak
Super User
Super User

Syndicated - Outbound

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)