Forum Discussion

meIdo's avatar
meIdo
Helper I
3 years ago

Data not filtering

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!

Need Help

2 Replies

  • HoangHugo's avatar
    HoangHugo
    Solution Specialist
    3 years ago

    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's avatar
      meIdo
      Helper I
      3 years ago

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