Forum Discussion
Solved
timeline slicer multiple sources
Hi There, I have a few datasets I'm combining for a marketing dashboards - I have facebook data, lead gens, and some sendgrid email status data all broken out by day or per event with a datetimez...
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
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/