Module 05 · Data Model & measures

Sort months January to December

Set Sort by Column once so the months in every chart run January to December instead of alphabetically.

Step by step5 minLesson 20 of 37 Members

A classic problem: in charts, the months appear as April, August, December, February… (or April, Agustus, Desember, Februari… on Indonesian settings), because Excel sorts text alphabetically. The Bulan column in Kalender needs to be told to follow the numbers in No Bulan (1 to 12). You set this once in the Data Model, and every chart, slicer and PivotTable gets it right.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

6 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons