Forum Discussion

t0talz's avatar
t0talz
Regular Visitor
8 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

t0talz,

Please help to share dummy data of your tables and post expected result here.

Regards,
Lydia

t0talz's avatar
t0talz
Regular Visitor
8 years ago

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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