Same slicer on 2 different pivot tables

[olivierhbh]

Hello,

I just discovered that if I create a slicer for a specific table, then create another table and add the same slicer, they auto connect each other. Do you know why is that and if I can disable it?

When I say I "add the same slicer", I don't mean I connect the first one to the two tables but literally create it.

Indeed if I untick the non concerned tables in the slicers connections, I get an Information saying: The following slicers will all be connected to this Pivot Table because they belong to the same hierarchy.


Thank you,
Olivier.

 

[scottsen]

I don't think your issue is directly with slicers so much as your pivot tables are "connected". Like, you copy and pasted a pivot table... and now they are forever "linked". I don't know of an easy way to "unconnect" them.

 

[olivierhbh]

Hi Scott,

Thank you for your answer. I don't understand how could my pivot tables be connected, I never copy-paste pivot tables, they don't have much in common except that they pull some data from a common table and that they have a slicer in common. I will try tommorow to create 2 dummy pivot tables with a common slicer to see if they "autoconnect", because to me it's what happened..

 

[ImkeF]

Hi Olivier,
How do you then create your Pivots?

When I'm using this approach, I can add independent slicers (or take the existing ones, which surprises me): Insert – PivotTable – Use external data source (2nd option) – Choose Connection – Tables (2nd slide) – This Workbook DataModel – Tables in Workbook Data Model

 

[olivierhbh]

Hello Imkef, indeed I use this process to create my tables.

Here is the result of my tests this morning:
- New sheet, new power pivot table, I add a few fields then the slicer and bam, it connects to all the tables which have this slicer.
- In the same sheet I create 3 other identical power pivot tables and the same slicer, slicers are independent and work as expected, without changing any other slicer.

I don't get it, maybe I should each time I add a slicer if it connects to other tables, but that would be heavy...

Any idea?

 

[ImkeF]

No sorry, no further ideas from my side here.