Impossible to connect slicer to multiple pivots charts on excel mac

Copper Contributor

Hi, I'm trying to connect a slicer to multiples pivots charts, but unfortunately it's not working.


In the report connections section of the slicer, I can only select 1 table. Other table are not showing up.

(see screenshot below)



Slicer Report Connections


Both of my tables have the same columns:

- Date 

- Values

- Country


So logically, my slicer who's connected to "Country" should be able to work on both graph.


1st pivot table:



1st pivot table


2nd pivot table:




I'm using the version 16.79.2 on mac. 

I would really appreciate your help :)


1 Reply

@TheoT1645 For slicers to connect to multiple pivot tables/charts those pivot tables/charts must share the same pivot cache (i.e. the same data source). From your description it seems that you have two different data sources (the green tables), though I can't tell for sure from the screenshot as the resolution is too low to see what's in them).