Forum Discussion
timeline slicer multiple sources
Hey BenMcChesney,
You are going to need a Calendar dimenson table to achieve what you want (Check out the link here). Once you have created the Calendar table, you can build relationships from your datasets to the Calendar table based on the datetime columns and then use the common Calendar date to show data from all the datasets.
Hope this helps,
Alan
Solution SupplierHey BenMcChesney,
You are going to need a Calendar dimenson table to achieve what you want (Check out the link here). Once you have created the Calendar table, you can build relationships from your datasets to the Calendar table based on the datetime columns and then use the common Calendar date to show data from all the datasets.
Hope this helps,
Alan
Oh awesome, thanks for the quick reply, I'll this is a shot in the next few days and report back !
That advice worked! Thanks so much. I ended up following the instructions here https://gqbi.wordpress.com/2016/09/07/create-dynamic-periods-for-fiscal-or-calendar-dates-in-power-bi/