I am currently pulling a dashboard together in which there are multiple data sources showing different information. I've created a number of pivots from these and have slicers linked to all pivots coming from the same table.
However is it possible to link a slicer between pivots which come from different data sources?
For example in both of my data sources there is a column title Payroll Week for which the Weeks in the column are the same across both data sources. However as I need historical data included this means that the contract names are repeated in each column which is what is currently stopping me being able to create a relationship between the two tables.
For example on the attached I've got two different data tables, creating pivots of different data however the weeks are the same, is there anyway to link it so when I click on Week 1 on one slicer it changes both pivots?
Thanks,
David
Bookmarks