Slicer setting issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1252772%22%20slang%3D%22en-US%22%3ESlicer%20setting%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252772%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20with%20different%20pivot%20tables%20in%20several%20tabs%2C%20based%20on%201%20data%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20slicers%20to%20filter.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIN%20some%20tabs%20when%20I%20add%20several%20slicers%2C%20the%20slicer%20settings%20work%20(like%20hide%20items%20with%20no%20data%20%3D%20blanc%20button%20disappears).%20When%20I%20select%201%20item%20in%20slicer%201%2C%20all%20irrelevant%20items%20in%20slicer%202%20disappear.%20This%20is%20what%20I%20expect.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20on%20other%20tab%20sheets%2C%20when%20I%20add%20several%20slicers%20(the%20same%20often)%2C%20the%20slicer%20settings%20do%20not%20work%20(like%20when%20I%20select%20%22hide%20items%20with%20no%20data%22%20nothing%20chages%20and%20the%20blanc%20button%20remains).%20When%20I%20select%201%20item%20in%20slicer%201%2C%20nothing%20changes%20in%20slicer%202.%20All%20items%20remain%2C%20while%20not%20all%20of%20the%20are%20relevant%20for%20the%20item%20selected%20in%20slicer%201.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%2C%20while%20I%20am%20only%20doing%20the%20same%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1252772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1714114%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20setting%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F594871%22%20target%3D%22_blank%22%3E%40Brains1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20experiencing%20the%20same%20issue%20with%20my%20slicers%20too.%3C%2FP%3E%3CP%3EMy%20file%20have%206%20slicers%20over%2048%20pivot%20tables%20created%20from%20a%20single%20data%20model.%3C%2FP%3E%3CP%3EIf%20anybody%20have%20any%20suggestions%2C%20please%20let%20us%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a worksheet with different pivot tables in several tabs, based on 1 data list. 

 

I am using slicers to filter. 

 

IN some tabs when I add several slicers, the slicer settings work (like hide items with no data = blanc button disappears). When I select 1 item in slicer 1, all irrelevant items in slicer 2 disappear. This is what I expect. 

 

But on other tab sheets, when I add several slicers (the same often), the slicer settings do not work (like when I select "hide items with no data" nothing chages and the blanc button remains). When I select 1 item in slicer 1, nothing changes in slicer 2. All items remain, while not all of the are relevant for the item selected in slicer 1. 

 

What am I doing wrong, while I am only doing the same 

 

1 Reply

@Brains1971 

 

I am experiencing the same issue with my slicers too.

My file have 6 slicers over 48 pivot tables created from a single data model.

If anybody have any suggestions, please let us know.