How to Sort Data in Power BI Chart

Sorting data in your Power BI charts is one of the quickest ways to transform a confusing visualization into a clear one that tells a story. When your bars, lines, or segments are logically ordered, your audience can instantly spot top performers, identify trends, and find the information they need without a struggle. This article will guide you through the essentials of sorting in Power BI, from basic value-based sorting to more advanced custom chronological and categorical sorting.

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 Does Sorting Matter in Data Visualization?

Sorting isn't just a formatting choice, it's a fundamental part of data storytelling. An unsorted chart forces the user to work hard, scanning back and forth to compare values and find what’s most important. A well-sorted chart, however, does the heavy lifting for them.

Here’s how effective sorting elevates your reports:

• It Highlights Key Information: Sorting a bar chart of sales by product from highest to lowest immediately reveals your best-selling items. You don't have to hunt for them.
• It Creates Logical Flow: Sorting a line chart by month chronologically (January, February, March...) creates an intuitive timeline that’s easy to follow. Unsorted (alphabetical) months would make the trend meaningless.
• It Improves Readability: When you have many categories, sorting them alphabetically allows users to quickly locate a specific item, such as finding their state in a long list.
• It Guides the Narrative: The order of your data guides your audience's attention. Direct them to the most important metric or the first step in a process by placing it at the top or on the left.

The Basics: How to Sort a Chart by Value

The most common sorting requirement is ordering a chart based on its numerical values, like sorting products by sales or campaigns by cost. This helps you see a ranked list, instantly revealing the highest and lowest performers.

Let's use a simple column chart showing Total Sales by Product Category as an example.

Step-by-Step Instructions:

1. Select the chart visual on your Power BI canvas to activate it. You'll see the border handles appear around it.
2. In the top-right corner of the visual, click the ellipsis icon (…) to open the "More options" menu.
3. Hover over Sort axis. A sub-menu will appear with your sorting options.
4. You will see two primary sorting fields: your axis field (e.g., ‘Product Category’) and your value field (e.g., ‘Total Sales’). Select the value field, Total Sales in this case.
5. The default selection will have a white circle next to it. After selecting Total Sales, Power BI will automatically re-sort the chart in descending order, putting the highest value first.
6. If you wish to switch to ascending order (lowest value first), simply go back to the "More options" menu and select Sort ascending at the bottom of the list.

That's it! Your Product Category chart is now neatly ordered from the highest-selling category to the lowest, making it instantly insightful.

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

Sorting by Axis Labels (Alphabetical Sorting)

Sometimes ranking by value isn’t the goal. Instead, you may want to help your users find a specific category quickly in a long list. In these cases, sorting alphabetically (or by the axis label) is the best approach.

Imagine a chart showing the number of customers in each US state. While you could sort it by the customer count, sorting the states alphabetically might be more useful for someone looking for data on a specific state like "California" or "Texas."

Step-by-Step Instructions:

1. Select the visual you want to sort.
2. Click the More options ellipsis (…) in the top-right corner.
3. Hover over Sort axis.
4. This time, instead of selecting the value field, select your axis field (e.g., ‘State’).
5. Power BI will now sort your chart based on the axis labels. The default is typically ascending (A-Z). You can change this to descending (Z-A) by clicking the ellipsis again and choosing Sort descending.

This method is perfect for charts where the name of the category is more important than its numeric rank.

Advanced Sorting: Creating Custom Sort Orders

Here's a problem almost every new Power BI user encounters: you create a chart showing data by month, and Power BI sorts it alphabetically — April, August, December, February. This is technically correct but analytically useless. You need it to be sorted chronologically.

This is where the powerful "Sort by Column" feature comes in. It lets you define a custom sort order for one column based on the values in another. To fix our month issue, we'll tell Power BI to sort the text-based 'Month Name' column using a numeric 'Month Number' column.

Here’s how to set it up:

Step 1: Get Your Data Ready

First, you need a helper column that defines the correct order. If you have a date table in your model (which is a best practice), you likely already have a 'Month Name' column and a corresponding 'Month Number' column (e.g., January = 1, February = 2).

If you don't have a numerical column for sorting, you need to create one. You can do this in Power Query or directly in your data model using DAX.

MonthNumber = MONTH('YourTable'[DateColumn])

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: Use the "Sort by Column" Tool

1. Go to the Data view in Power BI Desktop (the grid icon on the far left navigation pane).
2. Find and select the table that contains the column you want to sort (e.g., your Date table).
3. Click on the column that has the incorrect sort order. In our case, this is the 'Month Name' column. Do not click the 'Month Number' column here.
4. With the 'Month Name' column selected, the "Column tools" ribbon will appear at the top of the screen.
5. Click the “Sort by Column” button in the ribbon. A dropdown menu will appear.
6. From the dropdown, select the column that contains the correct order — in this case, 'Month Number'.

Power BI will process this logic in the background. Now, whenever you use the 'Month Name' field in any visual in your report, it will automatically sort chronologically. You don't need to adjust the sorting on each chart manually.

This technique is incredibly versatile and can be used for any non-standard sorting need:

• T-shirt sizes: Sort Size (Small, Medium, Large) using a 'Sort Order' column (1, 2, 3).
• Survey results: Sort Satisfaction Level (Very Dissatisfied, Dissatisfied, Neutral, Satisfied, Very Satisfied) using a numeric equivalent (1 to 5).
• Business-specific stages: Sort Sales Stage (Lead, Opportunity, Quote, Closed) using a stage number column.

Bonus Tip: Sorting in Tables and Matrix Visuals

While most of this article has focused on charts like bar and column charts, tables and matrices have a much more straightforward sorting process. You don't need to use the ellipsis menu.

To sort a table or matrix, simply click on the column header you wish to sort by. A small arrow will appear next to the header name, indicating the current sort direction.

• One Click: Sorts the table in ascending order (A-Z, lowest to highest).
• Second Click: Reverses the sort to descending order (Z-A, highest to lowest).
• Third Click: Removes the sort on that column.

This makes exploring raw data in a tabular format fast and intuitive, allowing you and your users to quickly rank a list by any metric available.

Troubleshooting Common Sort Issues

Sometimes sorting doesn’t behave as expected. Here are a few common problems and how to fix them.

Why is "Sort by Column" Greyed Out?

A common mistake is selecting the wrong column before clicking "Sort by Column." Remember: you must select the column you wish to change the behavior of (the text-based one, like 'Month Name'), not the column that contains the sort logic (e.g., '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

My Chart Keeps Reverting Its Sort Order!

Occasionally, a visual's sorting might seem to reset, especially if you remove and re-add fields. Always double-check the "More options" menu to confirm the sorting is still set correctly. If you've set up "Sort by Column" properly in the data model, the sorting should automatically apply correctly every time you add that field to a new visual.

Dates Are Not Sorting Correctly

If your dates are sorting like text (e.g., 1/1/2024, 1/12/2023, 1/2/2024…), it’s likely because the data type for that column is set to "Text" instead of "Date." Go to the Data view or Power Query Editor, select the date column, and change its data type to 'Date'.

Final Thoughts

Mastering the different sorting options in Power BI is a fundamental skill that significantly enhances the clarity and impact of your reports. By guiding your audience's attention with logical, well-ordered data, you turn visuals from simple pictures into powerful tools for decision-making. Whether it's a simple sort by value or a custom sort order for business logic, you're now equipped to handle it.

We know that building these reports, from connecting data sources to getting every chart just right, takes time and effort. We built Graphed to streamline this entire process. Instead of navigating menus and data models, you can simply ask in plain English for the reports you need. Just describe what you want, like "Show me sales by region in descending order for the last quarter," and Graphed builds a live, correctly sorted dashboard for you in seconds. It allows you to move directly from question to insight, bypassing an entire afternoon of manual work.