How to Shorten Month Name in Power BI

Your sales report is nearly perfect, but the full month names like "September" and "November" are getting truncated or overlapping on your chart's axis. It's a common problem that can make an otherwise brilliant dashboard look cluttered and unprofessional. This article will walk you through several straightforward methods to shorten month names in Power BI, so you can create clean, readable visuals.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Shortening Month Names?

Before jumping into the “how,” let’s quickly cover the “why.” It might seem like a small detail, but formatting your month names correctly has a big impact on your reports:

• Saves Space: This is the most obvious benefit. "Jan" takes up far less room than "January," especially on bar charts, line charts, and slicers. This prevents labels from overlapping or being cut off, which is essential for mobile views.
• Improves Readability: Shorter labels lead to a cleaner layout, making it easier for your audience to quickly understand the data. A well-designed chart shouldn't make people squint.
• Maintains a Professional Look: Consistent and clean formatting signals a well-built, thoughtful dashboard. It’s a small touch that separates amateur reports from professional ones.

The Foundation: A Proper Date Table

First things first, the best way to handle any kind of time-based analysis in Power BI is with a dedicated date table (also called a calendar table). While you can perform these formatting tricks on a date column in your main fact table, it's a strongly recommended best practice to have a separate table for all your date-related fields.

A good date table includes a column for every date in a given period and separate columns for attributes like year, quarter, month number, month name, and day of the week. This makes time intelligence DAX functions work seamlessly and keeps your data model organized.

For our purposes, your date table must have two key columns:

1. A date column (e.g., [Date]).
2. A month number column (e.g., [Month Number], 1 for January, 2 for February, etc.).

The month number is critical for sorting your shortened month names correctly, as we'll see in a moment.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Using Power Query's Built-in Features

Power Query is the data transformation engine inside Power BI, and it offers the most user-friendly way to achieve our goal without writing any code. This method involves extracting the first three letters from a full month name column.

Step 1: Open the Power Query Editor

From the main Power BI Desktop window, go to the Home tab and click on Transform data. This will open the Power Query Editor where you can shape your data before it's loaded into the model.

Step 2: Add a Month Name Column

In the Power Query Editor, select your date table. Then, select your primary date column. Navigate to the Add Column tab. In the "Date & Time Column" group, click on Date > Month > Name of Month.

This will create a new column containing the full name of the month (e.g., "January", "February").

Step 3: Extract the First Three Characters

Now, select the newly created "Name of Month" column. Go back to the Add Column tab, but this time look for the From Text group. Click on Extract > First Characters.

A dialog box will appear asking for the number of characters you want to extract. Enter 3 and click OK. Power Query will create a new column with the three-letter abbreviation you need (e.g., "Jan", "Feb"). You can now rename this column to something clear like "Short Month Name".

The Crucial Final Step: Correct Sorting

Once you close Power Query and return to Power BI, there's one critical issue to fix. If you use your new "Short Month Name" column in a visual, you'll see it sorts alphabetically: April, August, December, February, etc. This is not what you want.

Here's how to fix it:

1. Go to the Data view (the icon on the left that looks like a table).
2. Select your date table.
3. Click to select the "Short Month Name" column you just created.
4. The Column tools tab will appear in the ribbon at the top. Click on Sort by column.
5. From the dropdown menu, choose your Month Number column.

That's it! Now, whenever you use the "Short Month Name" column in a chart or table, it will sort chronologically from January to December.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Using a DAX Calculated Column

If you prefer working directly in the data model or want a more elegant solution than extracting text, you can create a shortened month name using a DAX formula. This approach is powerful and fast.

Step 1: Create a New Calculated Column

Go to the Data view in Power BI Desktop. Select your date table. In the Table tools or Home tab, click on New column.

Step 2: Write the DAX Formula

The formula bar will appear. Enter the following DAX expression, replacing 'Date Table'[Date] with the actual name of your date table and date column:

Short Month = FORMAT('Date Table'[Date], "MMM")

Let's break this down:

• Short Month =: This is the name we're giving our new column.
• FORMAT(...): A versatile DAX function that converts a value to text in a specified format.
• 'Date Table'[Date]: The date column we're basing our calculation on.
• "MMM": This is the format code. "MMM" tells DAX to display the three-letter abbreviation of the month.

Pro Tip: You can use "MMMM" to get the full month name or "MM" to get the two-digit month number (e.g., 01, 02).

Step 3: Set an explicit Sort by Column

Just like with the Power Query method, this newly created DAX column will sort alphabetically by default. You need to tell Power BI to sort it using the month number.

With your new "Short Month" column selected, go to the Column tools tab, click Sort by column, and choose your Month Number column. Your month names will now appear in the correct chronological order in all your visuals.

Method 3: Creating a Conditional Column in Power Query

This last method is more manual but is a great way to understand the logic behind data transformation. It's useful if you have very specific naming conventions beyond the standard abbreviation (e.g., "Jan.", "Feb."). You'll use a Conditional Column to explicitly define each short name based on the month number.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Add a Conditional Column in Power Query

Open the Power Query Editor, select your date table, and go to the Add Column tab. Click on Conditional Column.

Step 2: Define the Rules

A dialog box will open allowing you to set up if-then logic.

• Choose your Month Number column in the "Column Name" dropdown.
• Set the "Operator" to "equals".
• Enter 1 as the "Value".
• In the "Output" box, type Jan.
• Click Add clause.
• Repeat this process for all 12 months (e.g., if 'Month Number' equals 2, output Feb, if 'Month Number' equals 3, output Mar, and so on).
• You can leave the "Else" box blank or put an error message like "N/A".

Click OK when you're done. This creates a text column with your custom shortened names. The great thing about this method is that since you created it based on the month number in sequence, it might already sort correctly. However, it's always best practice to explicitly set the sort order as described in the previous methods to be certain.

Final Thoughts

Cleaning up your charts by shortening month names is a simple task that significantly improves data presentation. Whether you prefer the user-friendly interface of Power Query or the flexibility of a DAX formula, the key takeaway is to always set the correct sort order using a month number column. This ensures your time-based data is always displayed logically and intuitively for your audience.

Mastering these small formatting details is what separates good reports from great ones. But we know that getting bogged down in formatting options, sort orders, and DAX functions can take time away from actually finding insights. That's why we created Graphed . It's designed to be your AI data analyst, letting you skip the manual setup and simply ask for what you need in plain English - like "show me sales by month this year." We automatically handle the data connections, visualizations, and correct formatting in the background, so you can go from data to decision in seconds, not hours.