Controlling 2 sets of data with one date slicer

[Anonymous]

Hi

Is there and an easy an smart way to be able to control/manage to sets of data with one date slicer? Det 2 sets of data have their own seperat date and data series, but I would like to be able to slice both sets with one slicer.

Best regards

Niels

[Anonymous]

You should first learn data modelling and time-intel in PBI. Start with these:

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.youtube.com/watch?v=78d6mwR8GtA

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

Best
D

[iamdataagile · Accepted solution]

Hi,

You need a date table in your data model. You then create a relationship between the date column in your date table the date column in your data table. Do this for each of your two data tables. You can then use the date table as to filter the data in both tables. e.g. Add a the date column from the date table to the slicer. There are many ways to get a date table into your data model if you don't already have one, but perhaps the quickest is to create a new table in Power BI (New table is on the modelling ribbon) using the dax function CALENDARAUTO(). This will add a date table to your model. There's much more you can do to enhance this but basically this should do what you need. Hope that helps.