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)

TheoT1645_0-1703094574634.png

 

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:

TheoT1645_1-1703094574470.png

 

1st pivot table

 

2nd pivot table:

TheoT1645_2-1703094574177.png

 

 

I'm using the version 16.79.2 on mac. 

I would really appreciate your help :)

Thanks 

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).