Forum Discussion
Elliott
Advocate II
Advocate IISlicer to Cover Different Data Sources
Hello, Simple issue for what I assume should be a simple resolution but can't get my head round it. :smileyfrustrated: I currently have 2 sets of data, from SQL and Excel, in the same report ...
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
itchyeyeballs
Impactful Individual
Impactful Individual
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
the link doesn't work