slicer issues

%3CLINGO-SUB%20id%3D%22lingo-sub-3025704%22%20slang%3D%22en-US%22%3Eslicer%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3025704%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20attempting%20to%20attach%20multiple%20charts%20or%20pivot%20tables%20to%20a%20slicer%2C%20it%20fails%20to%20include%20all%20of%20the%20pivot%20tables%20or%20charts%20on%20the%20reported%20connections%20tab.%20Is%20there%20something%20that%20i%20am%20doing%20wrong%20or%20is%20there%20a%20particular%20way%20to%20format%20the%20slicer%20or%20pivot%20table%20to%20attach%20multiple%20ones%20together%3F%20I%20am%20stumped%2C%20youtube%20and%20my%20college%20professors%20havent%20been%20able%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3025704%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3026144%22%20slang%3D%22en-US%22%3ERe%3A%20slicer%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026144%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1235920%22%20target%3D%22_blank%22%3E%40Adamsne2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20connect%20a%20slicer%20only%20to%20Pivot%20tables%20that%20have%20the%20same%20source%20table.%20So%20if%20you%20have%20a%20Pivot%20that%20connects%20to%20source%20data%20table1%20and%20another%20Pivot%20that%20connects%20to%20source%20data%20table2%2C%20you%20would%20need%20two%20slicers.%3C%2FP%3E%3CP%3EOnly%20if%20all%20pivots%20connect%20to%20the%20same%20source%20table%2C%20you%20can%20control%20them%20with%20one%20single%20slicer.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

when attempting to attach multiple charts or pivot tables to a slicer, it fails to include all of the pivot tables or charts on the reported connections tab. Is there something that i am doing wrong or is there a particular way to format the slicer or pivot table to attach multiple ones together? I am stumped, youtube and my college professors havent been able to help.

1 Reply

Hi @Adamsne2021 

 

you can connect a slicer only to Pivot tables that have the same source table. So if you have a Pivot that connects to source data table1 and another Pivot that connects to source data table2, you would need two slicers.

Only if all pivots connect to the same source table, you can control them with one single slicer.