Slicer for Dates

Chris Sanders
Occasional Contributor



I had a slicer that used a date column from a table that previously worked fine giving the options in the date column;


Jan 2017

Feb 2017


Sept 2018


I've just moved PCs at work to one that has a slightly more up to date version of Excel and now the Slicer groups into Months;







And doesn't separate by year, so now all when I select a month it selects the data for that month from both 2017 and 2018.  


Can someone tell me why this has changed and if I can change it back? Thanks.


Kind Regards,


4 Replies
Can you perhaps attach a sanitized copy of the file?

It's a 50mb spreadsheet with 150k rows of data in the table the pivots are run off. Also as I dont have the older version of office I wouldn't be able to show what it was like previously...


I've attached a word file with a screen grab of the slicer, as you can see from that it doesn't differentiate by year at all, does this help?


Kind Regards,



But you should be able to remove a large number of rows of the source data and attach the shortened version? All that is probably needed is a handful of rows. Also, make sure you anonymise the data as well.

Yes, it looks like this in case you don't add data to data model


If right click and Ungroup it goes to


But better to work with data model initially




Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies