slicer not affecting my other visuals

[emmasd]

Hi,

I have tables as below:

each table has a "Symbol column" and the relationships are as below:

All tables are connected to information by "Symbol"

My slicers are only interactive if I use columns from the information table, I can not move the column "date" to the information table because the "Symbol" column in "Information" has unique values which is not the case in the "annual BS" and "annual IS" because each symbol has different values on different date as below:

The date slicer only works with either the "annual BS" if I use the date column from the same table, but it does noty interact with the other tables and visuals.

Also I checked the edit interactions under format and all is good there .

Any ideas???

[Shosher · Accepted solution]

Your relationship from the Date table to your central table is wrong. A date table should have one unique date for each row between a set date range. It is what is known as a dimension used to filter your facts. The facts would be in this case your central table. so the relationship should be always Date One -> Central table many. 

If for some reason you arent able to fix this right now because of date constraints we cannot see you can fix this right now by setting the filter direction in your date <- information relationship to both. This should fix it for now. You from that point on shouldnt really connect the date table to anything else because ambigious routes can and will exist!

[MFelix]

Hi @emmasd ,

Since the relationship is going from the Information table to the Date table the filter is only allowed in one direction so when you filter on dates it won't filter on the Information table that would filter other tables.

You need to check if the relationship is correct.

If you have a single date value on the Date table try to reverse the relationship from 1(information) to many  (Date) and be 1( Date) to many (information)