Multi-Select Slicer - Need to Select Rather than De-Select

%3CLINGO-SUB%20id%3D%22lingo-sub-2013313%22%20slang%3D%22en-US%22%3EMulti-Select%20Slicer%20-%20Need%20to%20Select%20Rather%20than%20De-Select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013313%22%20slang%3D%22en-US%22%3E%3CP%3EI%20admit%20I%20tend%20not%20to%20use%20Slicers%20often%20-%20I%20find%20filters%20do%20the%20job%20in%20most%20cases%20-%20but%20for%20this%20particular%20spreadsheet%20I%20need%20to%20make%20it%20as%20easy%20as%20possible%20for%20others%20to%20view%20and%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20a%20few%20pivot%20tables%20in%20my%20workbook%20across%20various%20worksheets%2C%20and%20there%20tends%20to%20be%203%20or%204%20pivots%20for%20each.%26nbsp%3B%20With%20the%20single%20selection%20ones%20it's%20really%20easy%20-%20point%2C%20click%20and%20the%20data%20shows%20as%20it%20should.%26nbsp%3B%20The%20issue%20I've%20got%20is%20that%20I%20know%20the%20users%20will%20want%20to%20select%20more%20than%20one%20option.%26nbsp%3B%20For%20instance%2C%20I've%20got%20one%20slicer%20with%20a%20dozen%20or%20so%20options%2C%20and%20I%20expect%20that%20the%20majority%20of%20people%20will%20select%20about%203%20or%204%20options%20(any%20combination).%26nbsp%3B%20The%20slicer%20would%20need%20them%20to%20deselect%208%20or%209%20of%20the%20options%20though%20which%20doesn't%20seem%20the%20best%20way%20-%20especially%20when%20there%20are%20other%20slicers%20they'll%20want%20to%20use%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20best%20that%20I%20can%20think%20to%20do%20is%20keep%20the%20slicers%20to%20select%20one%20option%2C%20and%20then%20let%20additional%20options%20be%20selected%20through%20the%20filter.%26nbsp%3B%20Ideally%20for%20a%20multi%20select%20slicer%2C%20(I%20think)%20I'd%20want%20the%20first%20option%20selected%20to%20be%20a%20SELECT%2C%20and%20anything%20not%20selected%20would%20be%20DESELECTED%2C%20so%20that%20anything%20else%20clicked%20would%20be%20added%20rather%20than%20needing%20to%20click%20through%20and%20remove%20all%20unwanted%20ones.%26nbsp%3B%20Is%20that%20possible%3F%26nbsp%3B%20Is%20there%20a%20better%20(perhaps%20more%20obvious)%20way%20of%20keeping%20things%20as%20simple%20as%20possible%20for%20the%20users%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2013313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I admit I tend not to use Slicers often - I find filters do the job in most cases - but for this particular spreadsheet I need to make it as easy as possible for others to view and use.

 

I've got a few pivot tables in my workbook across various worksheets, and there tends to be 3 or 4 pivots for each.  With the single selection ones it's really easy - point, click and the data shows as it should.  The issue I've got is that I know the users will want to select more than one option.  For instance, I've got one slicer with a dozen or so options, and I expect that the majority of people will select about 3 or 4 options (any combination).  The slicer would need them to deselect 8 or 9 of the options though which doesn't seem the best way - especially when there are other slicers they'll want to use as well.

 

The best that I can think to do is keep the slicers to select one option, and then let additional options be selected through the filter.  Ideally for a multi select slicer, (I think) I'd want the first option selected to be a SELECT, and anything not selected would be DESELECTED, so that anything else clicked would be added rather than needing to click through and remove all unwanted ones.  Is that possible?  Is there a better (perhaps more obvious) way of keeping things as simple as possible for the users?

 

 

0 Replies