Forum Discussion

sdc's avatar
sdc
Helper I
5 years ago
Solved

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 con...
  • mahoneypat's avatar
    5 years ago

    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