Forum Discussion

TheoT1645's avatar
TheoT1645
Copper Contributor
Dec 20, 2023

Impossible to connect slicer to multiple pivots charts on excel mac

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 🙂

Thanks 

excel
Excel on Mac

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 21, 2023

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

     

Resources