Single Date Filter for multiple Tables that do no relate.

[Dalton948]

I have 6 Tables each with completely different data and the only thing i want to filter on between them is the date to get a snap shot of statistics for a current time period.


I tried copying the date column and simplifying its date format and then relating on that but that did not seem to be the answer.

these are the columns i need to be able to filter on.

These are the tables. I believe what i need to do is create a calendar dax formula but i haven't been able to piece it together yet. Any suggestions are welcome. End goal is to have a single slider that adjusts the metrics i have for each of these tables.

[Anonymous · Accepted solution]

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.

[Dalton948]

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.