How to Sort Waterfall Chart in Power BI

Building a waterfall chart in Power BI is a fantastic way to tell a story with your data, showing how bits and pieces add up or subtract from a whole. But you've probably hit a wall when you try to sort the categories in a specific, logical order. This article explains exactly how to take control of your waterfall chart's sort order, so you can present your data clearly and effectively.

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

What is a Waterfall Chart, Anyway?

Before jumping into the fix, let’s quickly cover why waterfall charts are so useful. In short, they’re perfect for visualizing the cumulative effect of a series of positive and negative values. Think of it like a financial storybook.

You start with a total, like your initial revenue, and then the chart walks you through each change - costs, expenses, refunds, and additional sales - until you arrive at the final number, like your net profit. This sequential view makes it incredibly easy for anyone to understand how you got from point A to point B.

Common examples include:

• Profit and Loss Statements: Showing how revenue is reduced by cost of goods sold (COGS), operating expenses, and taxes to reach net income.
• Inventory Tracking: Starting with beginning inventory, adding purchases, and subtracting sales to find the ending inventory.
• Project Budget Analysis: Visualizing how an initial budget is affected by various expenses and scope changes over time.

The storytelling power of these charts falls apart, however, when the story is told out of order. That's the problem we're here to solve.

The Sorting Challenge in Power BI

If you've ever tried to reorder the columns in a Power BI waterfall chart, you’ve likely felt a bit of frustration. You add your categories, drop in your values, and the chart appears... but it's sorted alphabetically. You click the three dots (...) at the top corner of the visual, go to "Sort axis," and find that the options are either grayed out or simply don't rearrange the categories the way you want.

Power BI doesn’t inherently know that "Revenue" should come before "Cost of Goods Sold," or that "Marketing Expenses" should follow "Operating Expenses." It just sees text and defaults to A-Z sorting. This is where most people get stuck, but the solution is surprisingly simple: you just need to give Power BI a little guidance.

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 Best Fix: Using 'Sort by Column'

The cleanest and most reliable way to enforce a custom sort order for any Power BI visual, including waterfall charts, is by using the Sort by Column feature. This involves creating a new column in your data table that explicitly tells Power BI the order you want your categories to appear in. Once you get the hang of it, you'll use this trick for all sorts of charts, not just waterfalls.

Here’s how to do it, step-by-step.

Step 1: Create a Sorting Column in Your Data

First, we need a "helper" column that defines our desired order. For this example, let's say we have a simple table of financial data and we want to create a profit and loss waterfall.

Our goal is to display the categories in this specific order:

1. Sales Revenue
2. Cost of Goods Sold (COGS)
3. Marketing & Ads
4. Salaries & Benefits
5. Office Rent

To do this, you need to add a numeric column that assigns an index number to each category. You can add this column directly in your source file (like an Excel sheet), in Power Query during the data import process, or with DAX after the data is loaded. Adding it in the source is often easiest if you have access.

Here’s what your table would look like with a new Sort Order column:

Notice that negative values, like expenses, represent decreases in the waterfall.

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: Assign the Sort Column in Power BI

Now that the data is structured correctly, you need to tell Power BI to use your new Sort Order column to sort the Category column.

1. Go to the Data view in Power BI (the icon looks like a spreadsheet on the left-hand navigation pane).
2. Find and click on your data table in the Data pane on the right to bring up its contents.
3. Select the column that contains your chart's categories (in this case, the Category column). Don’t click the Sort Order column itself, click the one you want to be sorted.
4. With the Category column highlighted, a new tab called Column tools will appear in the top ribbon.
5. Click the Sort by column button. A dropdown menu will appear listing all other columns in your table.
6. Select your new helper column, which is Sort Order in our example.

Power BI will process for a moment. You won't see any immediate change in the data table itself, but you've just created a powerful rule: any time the Category column is used in a visual, it should be sorted according to the Sort Order column, not alphabetically.

Step 3: Build Your Waterfall Chart

With the sorting rule in place, you can now build your visual.

1. Return to the Report view.
2. Add a waterfall chart visual to your canvas.
3. Drag the Category field into the Category well.
4. Drag the Amount field into the Y-axis well.

Voila! Your waterfall chart will now be perfectly sorted in the logical order you defined in Step 1. Your financial story, from revenue down to the final total, is now clear and easy to follow.

Using a Calculated Table with DAX for Sorting

Sometimes, you can't or don't want to modify the source data. In these situations, you can create a separate "sorting" table using DAX and create a relationship to your main data table. This is a bit more advanced but keeps your original data clean.

Here's how you might approach it:

1. Create a Mapping Table: Go to the Modeling tab and select New Table. Use a DAX formula to create a simple table containing only your categories and their desired sort order.

CategorySort = 
DATATABLE(
    "Category", STRING,
    "Sort Order", INTEGER,
    {
        { "Sales Revenue", 1 },
        { "Cost of Goods Sold (COGS)", 2 },
        { "Marketing & Ads", 3 },
        { "Salaries & Benefits", 4 },
        { "Office Rent", 5 }
    }
)

1. Create a Relationship: Go to the Model view and drag the Category column from your new CategorySort table to the Category column in your main data table. This creates a one-to-many relationship.
2. Apply the Sort Logic: Go back to the Data view, select your new CategorySort table, click on its Category column, and use the "Sort by column" feature to sort it by its Sort Order column.
3. Build the Chart: When building your waterfall chart, use the Category field from your new CategorySort table, and the Amount field from your original data table. Thanks to the relationship, it will filter and sort correctly.

Troubleshooting Common Issues

Even with this method, you might run into a couple of common stumbling blocks. Here’s how to fix them.

"My chart is still sorting alphabetically!"

This nearly always means the "Sort by Column" step wasn't applied correctly. Go back to the Data view and double-check two things:

• Did you select the category column itself before clicking "Sort by Column"? Many users mistakenly select the sort order column.
• Did you select the correct sort order column from the dropdown?

Re-apply the setting, and your visual should update automatically.

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 sort order column has to be a number, right?"

Yes, for best results, your sort order column should be a whole number data type. If it's formatted as text, Power BI might try to sort it alphabetically (e.g., sorting "1", "10", "2", "3" instead of "1", "2", "3", "10"). You can change the data type in Power Query or in the "Column tools" tab.

"Error message: 'There can't be more than one value in Sort Order...'"

This critical error message means you have duplicate values in your category column that are assigned different sort order numbers. For the Sort by Column feature to work, there must be a clean one-to-one relationship. Each unique category name (like "Sales Revenue") can only have one corresponding sort order value (like 1). Check your data for duplicates or inconsistent naming to resolve this.

Final Thoughts

Getting your waterfall charts to sort logically in Power BI isn't natively intuitive, but it becomes simple once you master the "Sort by Column" technique. By creating a helper column that defines your desired sequence, you can transform a confusing, alphabetically-sorted visual into a clear, compelling data story.

This whole process of creating helper columns and managing data relationships highlights the manual work still needed in many powerful BI tools. That's why we built Graphed. We envisioned a tool where you don't need to learn DAX or hunt for hidden settings to get your visuals right. You can simply connect your data and ask, "Create a waterfall chart showing my profit for last quarter," and our AI data analyst builds it correctly, with the logical sorting already understood. It's about turning hours of data wrangling into seconds of conversation, helping your team get insights faster than ever before.