Data not filtering

[meIdo]

Hi Guys!

I have 2 tables. One contains member data, shoping date and shop type, Other one contains shopping frequency (Summary) like how many shopping in Jan, Feb .... and there is no member data but contain shop type. I linked two table using Date table. (One to Many both). I created a Year slicer using linking table year and when I select any year it updates. However,  selecting shop type from shop_type_data does not update chart for waterfall visual. It has to be shop slicer from shop_type_frequency and only it updates data. 

I also made bidirectional relationships.

Thank you!

[HoangHugo]

Hi, you can create one more relation between Shop type Data and Shop Type Frequency (many to many or one to many). OR create one more middle table to connect two table by Shop type as well as Date table

[meIdo]

I did that but it says only one relation should be active..