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
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
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies