Forum Discussion
Single date slicer for two data sets
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?
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
2 Replies
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
That did it, thanks
