Forum Discussion
Filters aren’t responding as expected
Hi czrogers13 ,
Be aware that when using a one to many relationship on the visualizations where you add the common column you need to use the column on the one side so that everything works properly, meaning that if you have on that table columns that are on both table you need to use that as your slicer and your base on the information.
As a good practice you should hide the column on the many side of the relationship so that you do not use it on visualizations.
Super UserHi czrogers13 ,
Be aware that when using a one to many relationship on the visualizations where you add the common column you need to use the column on the one side so that everything works properly, meaning that if you have on that table columns that are on both table you need to use that as your slicer and your base on the information.
As a good practice you should hide the column on the many side of the relationship so that you do not use it on visualizations.
hey MFelix,
It's working now! I took your advice and went back to make sure that each filter was connected in the right direction, and I re-implemented the relationships in question. I don't know exactly what the fix was, but I'm guessing I had one of the fields backwards.
Thanks for the help!