Linking slicers with pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2692967%22%20slang%3D%22en-US%22%3ELinking%20slicers%20with%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abdzera_0-1630079593345.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306276i1B935298C93E1ACA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Abdzera_0-1630079593345.png%22%20alt%3D%22Abdzera_0-1630079593345.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20a%20question%20guys%2C%20why%20when%20i%20try%20to%20link%20this%20slicer%20to%20a%20certain%20sheet%2C%20she%20doesnt%20show%20up%20in%20the%20report%20connections%2C%20what%20should%20i%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2692967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693201%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20slicers%20with%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139586%22%20target%3D%22_blank%22%3E%40Abdzera%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPivotTable%2FChart%20slicer%20you%20may%20link%20to%20the%20object%20built%20on%20same%20data%2C%20is%20that%20the%20case%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693259%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20slicers%20with%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693259%22%20slang%3D%22en-US%22%3Eyes%20i%20think%2C%20i%20dont%20know%20much%20about%2C%20im%20learning%2C%20i%20just%20dont%20know%20why%20the%20sheet%20named%20''Grafico%20de%20despesas''%20dont%20show%20up%20there%20in%20report%20connections%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693400%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20slicers%20with%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139586%22%20target%3D%22_blank%22%3E%40Abdzera%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESlicer%20is%20connected%20to%20the%20PivotTable%2FChart%20or%20structured%20table%2C%20not%20to%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693422%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20slicers%20with%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693422%22%20slang%3D%22en-US%22%3Esorry%20my%20bad%2C%20so%20trying%20to%20connect%20the%20Slicer%20to%20the%20pivot%20table%2C%20but%20one%20of%20my%20pivot%20table%20that%20i%20created%20doesnt%20show%20up%20in%20the%20report%20connections%3C%2FLINGO-BODY%3E
Occasional Contributor

Abdzera_0-1630079593345.png

I have a question guys, why when i try to link this slicer to a certain pivot table, she doesnt show up in the report connections, what should i do?

9 Replies

@Abdzera 

PivotTable/Chart slicer you may link to the object built on same data, is that the case?

yes i think, i dont know much about, im learning, i just dont know why the sheet named ''Grafico de despesas'' dont show up there in report connections

@Abdzera 

Slicer is connected to the PivotTable/Chart or structured table, not to the sheet.

sorry my bad, so trying to connect the Slicer to the pivot table, but one of my pivot table that i created doesnt show up in the report connections

@Abdzera 

Does it aggregate the same data as other PivotTables?

Yes

@Abdzera 

Sorry, when i don't know. If data source is EXCACTLY the same for each PivotTable/Chart slicer shall be connectable to each of them. Perhaps you may share the file to check?

sure, where i can send to you? email?

@Abdzera 

You may attach to your reply, just remove confidential information if any.

image.png