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.
this is my current work around until i figure out how to reduce it to just one slider. I was able to consolodate some of the tables in the relationships where able. Allows me to use 3 date filters instead of 6.