Make slicers visible "On Demand".
Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up
The core benefit of this function would be to reduce the amount of physical space occupied by static slicers on a crowded pivot table page. Slicers are superior to report filter boxes since the indicate which field parameters are not available due to other filtering actions on the same pivot.
A VBA-enabled file is provided as an example, which is also published at www.contextures.com
Hmm.. interesting thought, and I can see how useful this could be!
Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.
Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!
Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!Ashvini Sharma
Lead Program Manager
I am definitely adding my vote to improving slicers, which I think are one of the best things that Excel has brought out in a long time, however, as another respondent has said, if you are working in a big spreadsheet and you want to alter your selection you have to scroll back to where the slicers 'live'.
My thought on this would be that we need to have a separate slicer pane, to the left or right of the spreadsheet, where you can toggle on or off - a bit like a filter list on amazon would work okay.
Or, the slicers could float at a fixed point on the screen as opposed to on the spreadsheet, so if you scroll down, they scroll with you.
It's a pity this suggestion doesn't have more votes, but I do hope Microsoft devs take note, and just to add my vote to the list, I'm going to start my own thread with my suggestion.
Beyond that, it would make it a great deal easier not to have to position slicers on extremely large shared worksheets somewhere in the precious real estate of the page. I work with a team that uses massive spreadsheets and they frequently access those on tablets or cell phones on location, so having to use so much space on slicers can become quite cumbersome.
It also makes some of the additional formatting problematic when I need the slicers to be easily accessible. As it is, I must reserve the top several rows to position the slicers needed. (Otherwise you end up with a single entry, but to change the slicer you must scroll down for pages to find it.)
When presenting on a TV you have limited space to show large spreadsheets in a meeting, and you may want to jump around with filters. Filters take time and a slicer is quick but takes up a lot of space on the screen. A pop up filter or one you could add to the ribbon would solve this.
Kim Mullins commented
Alex has a valid idea. We who use Slicers on a regular bases would welcome this feature!
Thank for keeping all the MS Product line number one in innovative tech. that makes our work less probematic, and delivery so professional looking!