Forum Discussion
Single Date Filter for multiple Tables that do no relate.
- Anonymous2 years ago
Hi Dalton948 ,
If I understand you correctly, each of your tables contains a date column, and then you want to filter the data in all the tables by a date slicer.
I recommend that you add an additional Calendar table that contains all the dates covered in the other tables. Then create a relationship between this table and the other tables.
Here is my sample data:And I use this DAX to create the Calendar table (The date span in my sample data is 2024.1.1-2024.4.10):
Calendar Table = CALENDAR(DATE(2024, 1, 1), DATE(2024, 4, 10))Then create relationships between these tables:
Use the Calendar Table to create the slicer and the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dalton948 ,
If I understand you correctly, each of your tables contains a date column, and then you want to filter the data in all the tables by a date slicer.
I recommend that you add an additional Calendar table that contains all the dates covered in the other tables. Then create a relationship between this table and the other tables.
Here is my sample data:
And I use this DAX to create the Calendar table (The date span in my sample data is 2024.1.1-2024.4.10):
Calendar Table = CALENDAR(DATE(2024, 1, 1), DATE(2024, 4, 10))
Then create relationships between these tables:
Use the Calendar Table to create the slicer and the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.