Forum Discussion

Kerk's avatar
Kerk
Frequent Visitor
3 years ago

Use slicer's value in a matrix visual

I have two tables 'Append1' and 'Append_Pivot2' The two tables have a "Many to many" cardinality on column [swimmer] with cross filter direction set to both.   I create a matrix visual where : m...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi Kerk 

 

Making the slicer not affect the matrix cannot break the filter passed by the relationship. I recommend that you remove the relationship between two tables. Then your measure should work. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.