Forum Discussion
Slicer for Dates
Hi, 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 t...
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,
Chris
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