Forum Discussion
Solved
How to make one table's date slicer affect another table's information?
I have 2 tables: the larger table (L) is of the aggregate data and the smaller table (S) has more specific data. S has columns for date, user, and the number of times the user failed to log in, ...
Are you joining these two tables on the date field?
If so, are they both formatted the same and set to the same datatype on the source column?
Also, in the relationship properties do you have the Cross filter direction set to single or both? If it is set to single, try setting it to both.
Are you joining these two tables on the date field?
If so, are they both formatted the same and set to the same datatype on the source column?
Also, in the relationship properties do you have the Cross filter direction set to single or both? If it is set to single, try setting it to both.
Anonymous
Thank you! Turns out the dates weren't formatted as dates, so that was the issue.