Sorting by month in Slicers

%3CLINGO-SUB%20id%3D%22lingo-sub-1405146%22%20slang%3D%22en-US%22%3ESorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405146%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ESomehow%20I%20am%20not%20able%20to%20sort%20my%20slicer%20by%20Months%20from%20Jan%20to%20Dec.%3C%2FP%3E%3CP%3EIt's%20sorted%20in%20Pivot%20Table%20and%20Chart%20but%20in%20slicer%20it%20starts%20with%20Apr%2C%20Feb%2C%20Jan%2C%20etc..%3C%2FP%3E%3CP%3EI%20tried%20to%20solve%20it%20in%20slicer%20settings%20and%20also%20via%20Options%26gt%3BAdvanced%26gt%3BEdit%20Custom%20Lists%26gt%3BImport%20list%20from%20cells%20but%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193277i14196933B3D49A1C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1405146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405256%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F673911%22%20target%3D%22_blank%22%3E%40Peter_Roel%3C%2FA%3E%26nbsp%3Bit%20can%20be%20done%20via%20Slicer%20Settings%2C%3CBR%20%2F%3EItem%20Sorting%20%26gt%3B%20Ascending%20(Oldest%20to%20Newest)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20check%20your%20months%20are%20saved%20as%20months%20and%20not%20as%20'text'%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405370%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3B-%20Thanks%2C%20but%20I've%20tried%20that%20but%20doesn't%20work%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405378%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405378%22%20slang%3D%22en-US%22%3Ecan%20u%20pls%20share%20the%20file%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1409457%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F673911%22%20target%3D%22_blank%22%3E%40Peter_Roel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20creating%20the%20PivotTable%20you%20added%20data%20to%20data%20model%20(default%20behaviour).%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20387px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193625i54A5A72C477EEB73%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20so%20you%20ma%20re-create%20the%20table%20without%20data%20model%3B%20or%20add%20one%20more%20column%20with%20month%20numbers%20and%20in%20Power%20Pivot%20sort%20months%20by%20this%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416286%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20you!!.%20I've%20added%20an%20extra%20column%20with%20the%20month%20numbers%20and%20now%20sorting%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416370%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20by%20month%20in%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F673911%22%20target%3D%22_blank%22%3E%40Peter_Roel%3C%2FA%3E%26nbsp%3B%2C%20good%2C%20thank%20you%20for%20the%20feedback%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

Somehow I am not able to sort my slicer by Months from Jan to Dec.

It's sorted in Pivot Table and Chart but in slicer it starts with Apr, Feb, Jan, etc..

I tried to solve it in slicer settings and also via Options>Advanced>Edit Custom Lists>Import list from cells but no luck.

 

Capture.PNG

 

Peter_Roel_0-1589969004143.png

 

Thanks

Peter

6 Replies
Highlighted

@Peter_Roel it can be done via Slicer Settings,
Item Sorting > Ascending (Oldest to Newest)

 

Also check your months are saved as months and not as 'text'

Highlighted

@bhushan_z - Thanks, but I've tried that but doesn't work

Highlighted
can u pls share the file
Highlighted

@Peter_Roel 

Most probably creating the PivotTable you added data to data model (default behaviour).

image.png

If so you ma re-create the table without data model; or add one more column with month numbers and in Power Pivot sort months by this column.

Highlighted

@Sergei Baklan Thanks you!!. I've added an extra column with the month numbers and now sorting works.

Highlighted

@Peter_Roel , good, thank you for the feedback