Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Impossible to connect slicer to multiples 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 ConnectionsSlicer 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 table1st pivot table

 

2nd pivot table:

Screenshot 2023-12-11 at 15.03.41.png

 

I'm using the version 16.79.2 on mac. 

I would really appreciate your help :)

Thanks 

0 Replies