Weekday Data not Recognized for Sorting on Slicer

[dhunton]

I have two tables of data that I am using to create Pivot Tables and Pivot Charts. Then I'm creating slicers which slice multiple charts from the two different sources (via technique from this video: https://www.youtube.com/watch?v=AibLsRM-QbI )

One of the slicers needs to be Day of the Week. Because my date/time fields are by the quarter hour over a full month of data, I created a column for "Day of Week," ran a calculation, then copied-and-pasted-as-values so that I could slice my pivots based on that column. Which works just fine for pivoting and slicing.

However, I want the slicer sorted Sun-Mon-Tue-Wed-Thu-Fri-Sat (chronological) not Fri-Mon-Sat-Sun-Thu-Tue-Wed (alphabetical). I tried sorting A-Z (thinking it would pull from the Custom List of the weekdays), I tried sorting by the order of the source data (having sorted that properly before creating the pivots in the first place). Neither worked.

I thought it might be because of the copy-and-paste step, but I don't know how to bypass that. So I tried converting the cells to text format. That didn't work.

I know there's probably a simple solution that I'm completely overlooking. Any help?

 

[dhunton]

I'm really at a loss. I know this is a fairly basic question for this forum (how to get Excel to recognize weekdays for sorting purposes), but I'm stumped.

 

[SpillerBD]

Custom List.

https://www.youtube.com/watch?v=GSrdiYzjNZ8

 

[SpillerBD]

Custom List.

https://www.youtube.com/watch?v=GSrdiYzjNZ8

Actually, you need to use PowerPivot and a Calendar table for your data.

 

[dhunton]

SpillerBD,

Can you explain why I need to use PowerPivot and a Calendar table? Thanks.

This is still driving me crazy.