Sorting Grouped Dates in Slicer

[tdahlman]

In my pivot table I have "Due Date" with is a column label.
I grouped the dates into weeks by using the "days" grouping and using 7 days.
I created a slicer to allow the user to select with week they want, but the slicer is sorted as though it's a text field and not a date field.

Example:
6/1/2015 - 6/7/2015
6/13/2016 - 6/19/2016
6/15/2015 - 6/21/2015
6/16/2014 - 6/22/2014

I want the slicer to sort by actual date.

I seriously appreciate any help that you can give me.

Thanks,
Travis

 

[gorem]

This is just a guess, but it looks like the values are not being sorted as dates because they aren't dates - they are text strings composed of two date values, some spaces, and a hyphen.

What I would generally do in this situation is simply use "week ending" as the slicer variable. By that I mean label the field "week ending" and only use the latter of your two dates.