Forum Discussion
Slicer to Cover Different Data Sources
You could try creating a seperate date table (some examples here - http://community.powerbi.com/t5/Desktop/How-to-mark-Date-table/td-p/3202
Then link your two data sources to this new date table (and not each other). Make sure the date format is the same in all three tables.
Should then let you filter all visulaisations from one slicer
You could try creating a seperate date table (some examples here - http://community.powerbi.com/t5/Desktop/How-to-mark-Date-table/td-p/3202
Then link your two data sources to this new date table (and not each other). Make sure the date format is the same in all three tables.
Should then let you filter all visulaisations from one slicer
Thank you for your response,
Indeed, creating a separate table specifically for 'Date' and linking both 'Date' columns from my other tables has resolved my issue.
Thank you :smileyhappy:
Good to hear it worked,
I should have added in my response that you should always use the lookup table as the data source for any slicers to make sure things work as expected.
Coming from a database background (rather than data warehouse) It was a bit counterintuitive for me at first to create a table containing nothing but date information rather than calculate on the fly, however having read up a few sources like this it now makes much more sense