Mar 24 2021 11:17 PM
So I have a client list with dates....
Filters correctly if I use the Filter in table.
Unsure why. Seems that the splicer actually only hunts for the first instance of the actual date and filters by that.
Any ideas if I can fix this or am I going to have to create a formula column to sort months properly?
Mar 25 2021 12:11 AM
@Davidm54 This seems to have been around since Slicers where introduced. Slicers on tables don't work very will with dates. The attached article describes the issue and the workarounds.
https://www.myonlinetraininghub.com/sorting-excel-date-slicers
Mar 25 2021 03:45 PM
Mar 25 2021 03:58 PM