Connect multiple pivots (with multiple data sources) to one slicer

Hi All,

In the attachment you can find the problem that I am facing. I made a simulation of the two pivots that I want to connect with a slicer. Does anyone know if there is a possibility to connect to pivot graphs with two different pivot tables?

Rg,

Jeroen

I don't have power pivot install on my pc to replicate, hence can't do it but if you import both data sets and join the Store PK to Store FK and join will be done and the whole data can then be linked to single pivot table and slicer
Hope it leads in a correct direction.