How to Sort Legend in Power BI

A Power BI chart without a well-ordered legend can be confusing and undermine the story you’re trying to tell with your data. If your month names appear in alphabetical order (April, August, December...) or your survey responses are jumbled, your audience will spend more time deciphering the visual than understanding the insights. Fortunately, Power BI gives you precise control over your legend’s sort order.

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

This guide will walk you through the most effective methods to sort your Power BI legends exactly how you want them, from creating simple helper columns to using dedicated sorting tables.

Why Does Legend Sorting Matter?

Before diving into the "how," it's important to understand the "why." Proper legend sorting isn't just about making things look tidy, it's a fundamental part of effective data visualization.

• Improves Readability: A logical sequence - like chronological months, days of the week, or sequential categories (e.g., Small, Medium, Large) helps users interpret the chart faster and with less mental effort.
• Provides Context: Sorting a legend by a specific metric (like sales volume) can instantly draw attention to your top performers, even in a crowded chart.
• Maintains Professionalism: Consistent and logical sorting across all your report visuals creates a polished, professional, and trustworthy dashboard. An alphabetically sorted list of months is a clear sign that the report wasn't finalized with care.

By default, Power BI sorts text alphabetically and numbers from largest to smallest. While this works in some cases, you’ll usually need a custom order to tell a clear and accurate story.

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: The "Sort by Column" Feature (The Best Go-To)

The most reliable and common way to fix legend sorting is by using the "Sort by Column" feature. The concept is simple: you create a new column that contains the numerical order you want, and then you tell Power BI to use that column to sort your text-based category column.

Let's walk through a classic example: sorting months chronologically.

Step 1: Create a Sorting Column

First, you need a helper column in your data that defines the correct order. If you have a date table (which is highly recommended in any Power BI model), this is very straightforward.

If your table contains a date column, you can create new columns for the month name and month number right in the Data view using DAX.

1. Navigate to the Data view by clicking the table icon on the left-hand navigation pane.
2. Select the table containing your date information (e.g., a 'Calendar' table or 'Sales' table with an 'OrderDate' column).
3. Go to the Table tools ribbon at the top and click New column.
4. First, let's create a column for the month name. Enter the following DAX formula and press Enter:

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

1. Next, click New column again to create our sorting column. Enter the following DAX formula, which extracts the number from the date:

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

You should now have two columns: the Month Name (which contains the full month name like "January") and the Month Number (which contains the corresponding numerical value "1").

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

Step 2: Apply the Sort by Column Rule

The magic happens here. Now we just tell Power BI to use the Month Number column to sort the Month Name column.

• Select the Month Name column that you just added by clicking on its header in the data view.
• Highlight the Column tools tab in the top ribbon.
• In the Column tools tab, click on the Sort by Column dropdown menu.
• From the list that appears, select your helper column's name, Month Number.

Power BI will take a moment to sort the data, but in the end, your values will appear in the correct order.

Step 3: Check the Result in Report View

Now that you have set the sort logic, go to the report view. When you use "Month Name" as the legend (in any visual, like a bar or line chart), it will automatically display in chronological order (January, February, etc.), instead of alphabetical (April, August, etc.).

Method 2: Create a Dedicated Sorting Table

If for some reason the helper column approach doesn't work, or you need to sort your legends in more elaborate or frequent ways, you can maintain order with a dedicated sorting table. This technique is especially useful if you have a long list of categories.

Step 1: Create the Sorting Table

• From the Power BI menu, go to the External Data tab and click on Enter Data.
• A window will pop up, prompting you to enter a table manually. Enter two columns: one for the categories you want to sort (e.g., "Quarter") and another for the numerical order (e.g., "Quarter Order").

Step 2: Create a Relationship

• Navigate to the Model view by clicking on the third icon in the left-hand navigation pane.
• If you haven’t already, create relationships between this new sorting table and your existing data table. This is where you establish connections between the two tables.

Step 3: Apply the Sort by Column Rule Again

• This is the same process as Method 1.
• It ensures that your legends display correctly in the report visuals.
• Locate the Sorting Table column.
• Go to the Column Tools ribbon and click on Sort by Column.
• Select the appropriate order column from the list.

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 4: Update Your Visuals

To put it all together, go to the report view and make sure every visual where you intend to use "Month Name" as a legend has this data label and ensures the legend is sorted based on the sorting table or your Month Number column to always display the legend in the chronological order as your desired narrative.

Conclusion

Sorting your legends correctly in Power BI is crucial for delivering clear and accurate data insights. Whether you use the "Sort by Column" feature or a dedicated sorting table, Power BI enables you to achieve the desired view for your audience. This attention to detail will not only show your professionalism but also enhance user experience as they can focus on the insights rather than organizing the data.

Discover the potential of Power BI in building professional-grade analytics by mastering features like legend sorting. More of these small techniques together make up the complete package, showing how effective use of data visualization tools can be. Utilize resources like DAX and relationships to ensure your work is as clear and precise as possible.