topic Controlling 2 sets of data with one date slicer in DAX Commands and Tips

Controlling 2 sets of data with one date slicer

Anonymous — Wed, 06 May 2020 10:24:49 GMT

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

Re: Controlling 2 sets of data with one date slicer

iamdataagile — Wed, 06 May 2020 10:57:16 GMT

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.

Re: Controlling 2 sets of data with one date slicer

Anonymous — Wed, 06 May 2020 12:35:18 GMT

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