Forum Discussion
Filter Same Values from different Dimensions with n:m resolved
Hi, i need to make a filter which applies to different visuals showing the same values from two different sources. This is hard to explain in one search engine keyword phrase, so I couldnt figure ...
I could solve the issue already. The thing is:
If I filter by clicking an element in a table, the same filter value does not apply to the second table. However I can use my matching table (which is used to resolve the n:m dependency) for filtering, so I add an slicer with the matching table. Now if I click a value for filtering the filter applies to both tables.
But isn't it strange? I wouldn't expect this behavior. If the connection is made, why does the filter only apply from the directly matching tables and not from un-directly matched tables?
t0talz,
This issue could be caused by unproper relationships between tables, change cross filter direction from single to both and check if the issue goes away.
Regards,
Lydia