Sorting Month (MMM) within Slicers

[Vivek D]

How can I add a slicer that shows months in the MMM format i.e. Jan, Feb, Mar, Apr, May...
and sorted as per calendar.

By default it just shows in alphabetical format.

 

[Luke M]

What does your source data look like? If it was really dates, then the Slicer would pick that up by default and show in the correct order. If it's just text strings showing the month name, you won't be able to shorten the name.

Also, by default XL comes preloaded with a custom list showing the months in correct order, which XL uses to sort in the correct order. I am not able to duplicate your problem with dummy data. Can you provide an example?

 

[vrunda]

I checked with some raw data n it worked. No date format required. Pls upload ur sheet/ file.

 

[Vivek D]

Attached a sample. There is a "Closed Date" column and the Month is derived from that =TEXT(ClosedDate,"MMM'YY") and this new column is used for the slicer.

 

[GFC]

Attached a sample. There is a "Closed Date" column and the Month is derived from that =TEXT(ClosedDate,"MMM'YY") and this new column is used for the slicer.

but the slices are still in alphabetic order... Apr, Aug, Dec, Jan, Jul, Jun, ... and Dec'14 in followed by Dec'15... at least on my PC...

 

[Vivek D]

but the slices are still in alphabetic order... Apr, Aug, Dec, Jan, Jul, Jun, ... and Dec'14 in followed by Dec'15... at least on my PC...

I don't want them in alphabetical order. I want them in Calendar order i.e. Jan, Feb, Mar, Apr...

 

[GFC]

I don't want them in alphabetical order. I want them in Calendar order i.e. Jan, Feb, Mar, Apr...

Sorry I did not realize it was your post... I thought it was an answer...

 

[Debraj]

Hi Vivek..

Close Months are actually TEXT, not DATE..

• In the pivot table Add Close Date in Rows Section.. (just for a while..)
• In the Row label section.. GROUP "CloseDate" with Month.
• Now remove the Close Date from the ROW Section..

Now Insert Slicer.. for Close Date..
You dont need those Close Month fields..

 

[vrunda]

Find file attached

 

[Vivek D]

Hi Vivek..

Close Months are actually TEXT, not DATE..

• In the pivot table Add Close Date in Rows Section.. (just for a while..)
• In the Row label section.. GROUP "CloseDate" with Month.
• Now remove the Close Date from the ROW Section..

Now Insert Slicer.. for Close Date..
You dont need those Close Month fields..

View attachment 8317

Thanks. Learnt something new today. Had known about the grouping feature but never used it before. I guess I'm going to use it a lot more in the future.

 

[Abrar]

Hi,
Following up on this, in my case, the slicer is based on power pivot column so this is not possible there. How to go around it?

 

[Abrar]

hmm solved it myself. decided to use timeline instead and it works perfectly for my purpose.