How to Change Month Order in Power BI

Nothing is more frustrating than building a beautiful chart in Power BI to track your business performance, only to see the months displayed out of order: April, August, December, February. That default alphabetical sorting can make a straightforward month-over-month report completely unreadable. This article will show you exactly how to fix this common issue. We will walk through the steps to correctly order your months chronologically using Power BI's built-in tools and explore best practices for handling dates in your reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Your Months Are Out of Order

The root of the problem is simple: by default, Power BI, like most analytics tools, sorts text-based fields alphabetically. When your date column is formatted as a month name (e.g., "January", "February"), Power BI sees it as just another piece of text. "April" comes before "August" in the alphabet, so that's how it orders your chart axis. It has no inherent understanding that "January" should actually come first in a calendar year.

To fix this, you need to provide Power BI with some extra context. You have to explicitly tell it, "Hey, when you see this column of month names, don't sort it alphabetically. Instead, sort it based on this other column that contains the correct numerical order (1 for January, 2 for February, etc.)." This is where the powerful "Sort by Column" feature comes in.

The Easiest Fix: The 'Sort by Column' Feature

Let's get straight to the solution. The most direct way to get your months in chronological order is by using a combination of a numeric month column and Power BI’s sorting feature. This process has two main steps.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Create a "Month Number" Column

Before you can tell Power BI how to sort your month names, you need a column that defines the correct order. You cannot sort the text "January" correctly without associating it with the number 1. If your data already has a month number column, you can skip to the next step. If not, don't worry - it’s easy to create one using a little bit of DAX (Data Analysis Expressions).

First, navigate to the Data view in Power BI by clicking the table icon on the left-hand toolbar. Select the table that contains your date or month name column.

In the "Table tools" or "Column tools" tab at the top, click on New Column. Now, paste the following DAX formula into the formula bar. Be sure to replace 'YourTable'[YourDateColumn] with the actual names of your table and date column.

Month Number = MONTH('YourTable'[YourDateColumn])

Press Enter. Power BI will instantly create a new column filled with numbers from 1 to 12 corresponding to the month in your date column. If you don’t have a full date column but only a month name column, you might need a more involved formula using a SWITCH function, but having a proper date column is always the best practice.

You may also want a column for the month name itself if your data doesn't already have one. You can create this with a similar DAX formula:

Month Name = FORMAT('YourTable'[YourDateColumn], "MMMM")

The "MMMM" format code tells Power BI to display the full month name (e.g., "January"). If you wanted a three-letter abbreviation, you would use "MMM" ("Jan"). Now you have both a text-based "Month Name" column to display on your chart and a "Month Number" column to use for sorting.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Apply the 'Sort by Column' Feature

With your two columns ready, you can now tell Power BI how to sort. Follow these simple steps:

1. While still in the Data view, make sure you have your table selected.
2. Click on the header of the column you want to sort, which is your month name column (e.g., "Month Name"). This is the field that displays on your report axis.
3. With the column selected, the Column tools tab will appear in the top ribbon.
4. In the "Sort" group, click the Sort by Column button.
5. A dropdown menu will appear. From this list, select the column you just created to define the order – in our case, the month number column ("Month Number").

That's it. Power BI now understands the relationship. It knows that whenever it encounters the "Month Name" column in a visual, it should use the "Month Number" column to determine the sort order. You can now return to the Report view, and your chart's x-axis should automatically reorder itself chronologically: January, February, March, and so on.

Best Practice: Building a Dedicated Date Table

While the method above works perfectly fine for a quick fix on a single table, Power BI is designed to work most effectively with a proper data model that includes a dedicated date table (also called a calendar table).

A date table is a separate table in your model that contains a continuous list of dates and various helper columns related to those dates (year, quarter, month name, month number, week number, etc.). This becomes the single source of truth for all things time-related in your report. Using one is a fundamental best practice for any serious Power BI development.

Three Reasons to Use a Date Table

• Centralized Logic: All your time intelligence calculations happen in one place. If you need to make a change, you only edit one table.
• Consistency: Ensures dates are handled consistently across all your reports and visuals.
• DAX Time Intelligence: A dedicated date table is required for most of Power BI’s powerful time-intelligence DAX functions, like calculating year-over-year growth (SAMEPERIODLASTYEAR) or daily moving averages.

Creating a Basic Date Table with DAX

You can create a new date table right inside Power BI using a DAX formula. Go to the Data view, and in the Home tab, click New Table.

A simple option is to use the CALENDARAUTO() function, which scans your entire data model for the earliest and latest dates and creates a table that spans that full range.

Date Table = CALENDARAUTO()

A more controlled approach is using the CALENDAR() function, where you specify the start and end dates:

Date Table = CALENDAR(DATE(2022, 1, 1), DATE(2025, 12, 31))

Once your table is created with a single [Date] column, you can add all the helper columns you need by clicking New Column:

• Month Name: Month Name = FORMAT('Date Table'[Date], "MMMM")
• Month Number: Month Number = MONTH('Date Table'[Date])
• Year: Year = YEAR('Date Table'[Date])
• Month & Year: Month Year = FORMAT('Date Table'[Date], "MMM YYYY") (e.g., "Jan 2024")
• Sortable Month Year: Sortable Month Year = FORMAT('Date Table'[Date], "YYYYMM") (e.g., "202401")

After adding these columns, you can apply the "Sort by Column" feature. For instance, you could select the "Month Name" column and sort it by "Month Number," and select the "Month Year" column and sort it by "Sortable Month Year."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Finishing Steps: Mark as Date Table and Create Relationships

After you’ve built your date table, there are two final, crucial steps:

1. Mark as Date Table: Right-click on your newly created date table in the Fields pane and select Mark as date table > Mark as date table. In the dialog box, select your primary [Date] column. This tells Power BI that this is your official calendar.
2. Create a Relationship: Go to the Model view (the third icon on the left). Drag your [Date] column from the newly created Date Table and drop it on top of the date field in your main data table (e.g., your Sales table's 'OrderDate' column). This creates a one-to-many relationship, connecting your calendar to your events.

Now, for all your charts, you should use the date hierarchy fields from your Date Table, not the original date field from your sales data table.

Troubleshooting Common Issues

Even with the steps above, you might occasionally run into an issue. Here are a few common stumbling blocks and how to fix them:

• Sorting is Still Wrong: Double-check that in your visual, you are sorting the axis by the month name field and not by your sales/revenue measure. Click the three dots (...) at the top-right of your visual, go to "Sort axis," and ensure it’s selected on your month field with an ascending sort.
• The 'Sort by Column' Button is Grayed Out: This happens if you haven't first selected a column from the main data pane. Remember to click the header of the column you want to sort before clicking the button in the ribbon.
• Many-to-Many Relationships: If your original date column contains duplicate dates, creating a date table relationship properly might be tricky. Ensure your primary key in the Date Table (the [Date] column) has unique values for a clean one-to-many relationship.

Final Thoughts

Fixing the month sort order in Power BI is a classic rite of passage for new users. By telling your text-based month names to sort according to a numeric month column, you can override the alphabetical default and present your data logically. Using a dedicated, well-structured date table is the best-practice approach that sets your reports up for more advanced and reliable time-based analysis down the road.

While getting comfortable in tools like Power BI unlocks powerful customization, it often involves a steep learning curve of DAX formulas and data modeling quirks just to answer simple questions about your business. This is exactly why we built Graphed. We believe you shouldn't have to become a data specialist or search for tutorials just to understand your sales performance. You can connect all your marketing and sales data sources in seconds, and then simply ask in plain language, "Create a report showing revenue by month for the last year" and get a perfectly sorted, real-time dashboard instantly, with no formatting required.