Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

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 u...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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