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
Alex Jankowski
shared this idea
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
Excel
3 comments
-
Maya
commented
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.)
-
Carl
commented
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!