How to Sort Filter in Power BI

Having a filter in Power BI sort in a random or alphabetical order when you need a specific, custom sequence can be incredibly frustrating. A perfectly designed report can lose its impact if the slicer shows "High," "Low," and "Medium" instead of the logical "High," "Medium," "Low." This tutorial will show you exactly how to take control and sort any filter or slicer in your Power BI reports.

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

Understanding Default Sort Behavior in Power BI

Before we jump into the fixes, it helps to know why Power BI sorts things the way it does out of the box. By default, Power BI applies a simple logic:

• For text values (like names or categories): It sorts alphabetically (A-Z). This is why "December," "February," and "January" will appear in that order, not a chronological one.
• For numerical values: It sorts numerically, either ascending (smallest to largest) or descending.

The challenge arises when your data has a natural but non-alphabetical order. Think of months in a year, days of the week, or priority levels like "Low, Medium, High." Fortunately, there's a straightforward way to fix this.

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

The Easiest Fix: Sorting Directly on the Visual

Sometimes, all you need is a simple ascending or descending sort on the slicer itself. This is the quickest way to get an alphabetical or numerical sort without diving into the data model.

1. Select the slicer or filter visual on your report canvas.
2. Click the ellipsis (...) in the top-right corner of the visual.
3. Hover over "Sort ascending" or "Sort descending." You'll see an option to sort by the specific field used in your slicer.
4. Click to apply the sort.

While easy, this method is limited. It only sorts by the field already in the slicer and won’t help with custom sorting, like putting months in chronological order. For that, you need a more powerful tool.

The Best Method: Using "Sort by Column" for Custom Orders

The most robust way to control sort order is the Sort by Column feature. This lets you define a specific order for one column based on the values in another column. Our most common example is sorting month names ("January," "February") using their corresponding month number (1, 2).

Let's walk through this process step-by-step.

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 1: Identify or Create a "Sorting Column"

To sort a column (e.g., "Month Name"), you first need another column that holds the correct numerical or chronological order (e.g., "Month Number"). If you're lucky, this column already exists in your dataset. If not, you'll need to create it. You can do this in Power Query during data import, but creating it with DAX is often faster for existing models.

Imagine your table "SalesData" has a [Date] column, but you want to sort a [Month Name] column you created. You need to create a [Month Number] column for sorting.

1. Go to the Data view by clicking the table icon on the left-hand navigation pane.
2. Select the table you want to modify (e.g., "SalesData").
3. In the "Table tools" ribbon at the top, click New Column.
4. Enter the following DAX formula. This formula creates a new column called "Month Number" that extracts the month number from your 'Date' column:

Month Number = MONTH(SalesData[Date])

You now have a helper column that contains the correct sort order (1 for January, 2 for February, etc.).

Step 2: Apply the "Sort by Column" Setting

Now you'll tell Power BI to use your new "Month Number" column to sort your "Month Name" column.

1. While still in the Data view, click to select the column you want to sort (not the helper column!). In our example, you would click anywhere in the "Month Name" column to make it active.
2. With the "Month Name" column selected, the Column tools tab will appear in the top ribbon.
3. Click the Sort by Column button.
4. A dropdown menu will appear. Select the helper column you created: "Month Number".

That’s it! Power BI might take a moment to process, but behind the scenes, it has just created a rule: "Whenever you display the 'Month Name' column, sort it according to the 'Month Number' column."

Step 3: Check Your Report

Now, go back to the Report view (the first icon in the left-hand navigation). Look at the slicer or filter that was previously sorted incorrectly. It should now be perfectly sorted in chronological order: January, February, March, and so on. This logic will apply to that column anywhere it is used in your report— in tables, charts, or other visuals.

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

Practical Tips for Sorting Success

• Universally Applicable: This "Sort by Column" method works for anything with a custom order: product sizes (Small, Medium, Large), survey responses (Poor, Fair, Good, Excellent), or company-specific tiers (Bronze, Silver, Gold). Just create a helper column with a numerical index (1, 2, 3) representing your desired order.
• Consistency is Key: Make sure there's a one-to-one relationship between the values in the column you're sorting and the values in your sorting column. For example, every "January" must correspond to a "1," every "February" a "2," and so on.
• Hide the Sorting Column: Once you've set up your sort, you don't need to see the helper column in your report. In the Data view or Model view, you can right-click your sorting column (e.g., "Month Number") and select Hide in report view. This keeps your field list clean for you and other report builders.

Final Thoughts

You've now seen how to master filter sorting in Power BI, moving from simple alphabetical clicks to the more powerful "Sort by Column" feature. Creating a simple helper column with DAX gives you complete control over how your filters and slicers are displayed, making your reports more intuitive and professional.

While mastering specific features in Power BI is a valuable skill, spending time figuring out sorting rules is one of the many small hurdles that can slow down your reporting workflow a lot. At Graphed, we’ve re-imagined this entire process. Instead of creating DAX columns and navigating menus, you simply ask in plain English: "Show me my sales by month this year," and we automatically build a chart with the months correctly sorted. We connect directly to your marketing and sales data, letting you create dashboards and get answers in seconds, not hours.