I had a slicer that used a date column from a table that previously worked fine giving the options in the date column;
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.
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?
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