Single date slicer for two data sets

[sdc]

I have two distinct data sets that each contain a date field along with separate number values for each date.

Instead of having one date slicer for each data source I would like to have one that controls both graphs at the same time.

How do I link the two date fileds together?

[sdc]

That did it, thanks

[mahoneypat · Accepted solution]

You can add a Date table to your model and make a relationship to each table to one of the date columns.  You can then make a single slicer from a column in your Date table and use the Date columns in your charts to get your result.

Creating a simple date table in DAX - SQLBI

Pat