Forum Discussion
Date Slicer not working
Hi, I have two tables and each table has two common columns (Date and Customer) that I want to slice and dice. The Date slicer does not filter TableB, how to solve this? I came across articles about...
Back2Basics
Resolver I
Resolver IThe date that you are trying to filter on is only in one of the tables. Although it looks like the dates are in both it is different data.
I think you can work around this though. If you duplicate one of your tables, I would suggest the one with the most rows, then remove all columns except for the date column. Rename the table to something sensible like 'Date'. Then recreate a relationship between this new table and each of your other tables, both directions. Now you should be able to create your filter using this new table and the date field from it. This should then filter across both for you.
I've not tried this out, but thinking it should work.