Forum Discussion

Peter_Roel's avatar
Peter_Roel
Copper Contributor
May 20, 2020

Sorting by month in Slicers

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...
BI & Data Analysis
Charting
excel
bhushan_z's avatar
bhushan_z
Iron Contributor
May 20, 2020

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'

  • Peter_Roel's avatar
    Peter_Roel
    Copper Contributor
    May 20, 2020

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

Resources