Home

Pivot table slicer returns inverse selection?

%3CLINGO-SUB%20id%3D%22lingo-sub-331121%22%20slang%3D%22en-US%22%3EPivot%20table%20slicer%20returns%20inverse%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331121%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3A%20New%20to%20the%20community%20and%20not%20an%20Excel%20expert%20so%20I'm%20hoping%20someone%20can%20help.%20I'm%20using%20Excel%202016%20in%20Office%20365%20ProPlus%20(v1803%3F).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20pivot%20table%20and%20added%203%20slicers%20to%20help%20users%20filter%20the%20data.%20I%20note%20that%20they%20all%20have%20a%20%22multi-select%22%20icon%20(next%20to%20the%20%22clear%20filter%22%20icon).%20For%202%20of%20the%203%2C%20it%20works%20perfectly%20fine.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20for%20the%20other%20one%20(which%20I%20anticipate%20will%20be%20the%20one%20users%20would%20most%20need%20to%20use%20multi-select)%20I'm%20finding%20that%20when%20I%20activate%20that%20button%20and%20select%20multiple%20items%20from%20the%20selector%2C%20those%20items%20get%26nbsp%3B%3CEM%3Edeselected%3C%2FEM%3Ein%20the%20pivot%20table.%20It's%20almost%20like%20it's%20doing%20an%20inverse%20of%20what%20I%20want%20to%20select.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20delete%20and%20rebuild%20the%20slicer%20(though%20not%20yet%20the%20whole%20thing)%20but%20that%20didn't%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20seen%20this%20and%20if%20so%2C%20do%20you%26nbsp%3B%20have%20any%20suggestions%20on%20how%20to%20fix%20it%3F%20This%20will%20be%20distributed%20to%20users%20who%20may%20not%20have%20the%20most%20up%20to%20date%20version%20of%20Office%20so%20I'm%20not%20going%20to%20try%20anything%20%22fancier%22%20like%20the%20Power%20Apps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20they%20could%20just%20use%20the%20filter%20in%20the%20pivot%20table%20column%20but%20where's%20the%20fun%20in%20%3CEM%3Ethat%3C%2FEM%3E%3F%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-331121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
DESpencer
Regular Visitor

Hi all: New to the community and not an Excel expert so I'm hoping someone can help. I'm using Excel 2016 in Office 365 ProPlus (v1803?). 

 

I created a pivot table and added 3 slicers to help users filter the data. I note that they all have a "multi-select" icon (next to the "clear filter" icon). For 2 of the 3, it works perfectly fine. 

 

However, for the other one (which I anticipate will be the one users would most need to use multi-select) I'm finding that when I activate that button and select multiple items from the selector, those items get deselected in the pivot table. It's almost like it's doing an inverse of what I want to select.

 

I did delete and rebuild the slicer (though not yet the whole thing) but that didn't help. 

 

Has anyone seen this and if so, do you  have any suggestions on how to fix it? This will be distributed to users who may not have the most up to date version of Office so I'm not going to try anything "fancier" like the Power Apps.

 

I know they could just use the filter in the pivot table column but where's the fun in that??

Thanks in advance.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies