Forum Discussion
Slicer vs Filter
Hello All,
I would like to use a slicer for a date field to use the way the the filter summarizes/collapses individual days into months. The slicer is not valuable the way it lists each individual date, please see screen shot of filter and slicer side by side.
Thanks. 😊
Hi Joel,
Excel doesn't allow to group within the slicer. The workaround could be to create one more helper column for the parent slicer, like this
8 Replies
Hi Joel,
Excel doesn't allow to group within the slicer. The workaround could be to create one more helper column for the parent slicer, like this
Thank you Sergei,
Here is the slicer with the helper column. 😊
Joel, you are welcome. In general you may hide column A, it changes nothing in slicer behaviour.
- Can you not use the Timeline slicer?
I'm not seeing the timeline slicer on my ribbon, are you on a pc?
Timeline is for PivotTable, not for the table (if only you didn't load it into the data model) and for Excel 2013, 2016.
