Register
Log In
Unanswered
Home
New Member
February 2, 2017
Offline
I have a slicer for months in a pivot table and it works fine when I select the month(s) but if I 'Clear Filter' the month custom sort order in the pivot table returns to alphabetical. Am I missing something or is this something I have to work around?
Thanks.
July 16, 2010
Offline
Hi Brent,
It sounds like you haven't used a date field and then grouped them into months. When you use a proper date field and then grouping, the PivotTable knows to sort the months correctly, but when you use a text field for 'month' Excel doesn't know this text is actually a month and you must resort to more manual ways of sorting.
You've discovered a limitation of this approach. I recommend you insert a proper date field and then group them into months so you can avoid custom sorting.
Mynda
Dashboards
Power BI
Power Query
April 21, 2015
Offline
That reminds me of an item I once read where you can make your own sorting list in the way you want it sorted. So if it's text and the purpose is to remain it as text, maybe that's something for you?
On the other hand it's strange that it functioned normal and now doesn't after a while.
If you want to know how to make that sorted list, I'll look for that.
Most Users Ever Online: 57
Currently Online: Max Neumann
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
