Slicer and Pivot Chart Controls

%3CLINGO-SUB%20id%3D%22lingo-sub-2153860%22%20slang%3D%22en-US%22%3ESlicer%20and%20Pivot%20Chart%20Controls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153860%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20slicer%20to%20control%20a%20specific%20pivot%20chart.%26nbsp%3B%3CSPAN%3EI%20want%20to%20create%20an%20exact%20copy%20of%20the%20pivot%20chart%20and%20slicer%20but%20only%20control%20the%20copied%20pivot%2Fpivot%20chart%20with%20the%20second%20slicer%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20copied%20second%20pivot%20chart%20and%20slicer%20are%20cut%20from%20the%20report%20connections%20but%20the%20connection%20affects%20the%20first%20slicer.%20How%20do%20I%20fix%20this%3F%20The%20pivot%20and%20pivot%20chart%20are%20based%20on%20the%20same%20report%20data.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2153860%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I created a slicer to control a specific pivot chart. I want to create an exact copy of the pivot chart and slicer but only control the copied pivot/pivot chart with the second slicer?

 

The copied second pivot chart and slicer are cut from the report connections but the connection affects the first slicer. How do I fix this? The pivot and pivot chart are based on the same report data. 

1 Reply
Simple one is make table then Slicer for it and finally create Pivot chart,, then use the Slicers,, you will find effects on Chart also!