How to Make a Waterfall Chart in Power BI

A waterfall chart is one of the best ways to visualize a financial statement or track changes to a value over time. Instead of just showing a flat starting and ending point, it tells the story of what happened in between. This post will walk you through exactly how to create a useful and easy-to-read waterfall chart in Power BI, step by step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Waterfall Chart Anyway?

Think of a waterfall chart as a visual representation of a journey. It shows a running total, illustrating how an initial value is affected by a series of positive (increases) and negative (decreases) changes. Each bar seems to "hang" or "float," leading from the end of the previous bar to the start of the next, creating a cascade-like appearance.

By default, up-and-down bars are color-coded - typically green for positive and red for negative - making the impact of each category instantly clear. The first and last columns represent the total starting and ending values.

When Should You Use One?

Waterfall charts aren't for every dataset, but they are incredibly effective in specific scenarios, such as:

• Analyzing Financial Statements: Their most common use case is visualizing a Profit & Loss (P&L) statement. You can start with total revenue, subtract costs of goods sold and operating expenses, and end with the net profit.
• Tracking Project Budgets: Start with the total budget allocation. Then, show deductions for each major expense category (labor, materials, software) to see how the remaining budget shrinks over time.
• Monitoring Sales Pipeline Changes: Show the number of leads at the start of the quarter, add new leads, subtract disqualified leads, and end with the current number of active opportunities.
• Viewing Inventory Levels: Start with beginning inventory, add new stock received, subtract units sold or lost, and arrive at the ending inventory count.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Getting Your Data Ready

Before you jump into Power BI, it's essential to structure your data correctly. The waterfall chart visual requires two main things:

1. A Category column that contains the name of each stage or change (e.g., "Sales Revenue," "Operating Costs," "Gross Profit").
2. A Value column that contains the numeric amount for that category. For increases, these values should be positive numbers. For decreases, they must be negative numbers.

Here’s what a simple dataset for a P&L statement might look like in a table. Notice how expenses are entered as negative values.

You may also have sub-totals like "Gross Profit" in your financial data. For now, you can leave them out of your source table. We’ll show you how Power BI can calculate and display these automatically.

Step-by-Step: How to Build Your Waterfall Chart in Power BI

Once your data is clean and loaded, creating the basic chart takes just a few clicks.

Step 1: Open Power BI and Load Your Data

Launch Power BI Desktop. Use the Get Data option on the Home ribbon to connect to your data source, whether it’s an Excel file, a CSV, or a database.

Step 2: Select the Waterfall Chart Visual

In the report view, find the Visualizations pane on the right-hand side. Click on the icon for the waterfall chart to add an empty visual to your report canvas. It looks like a bar chart with floating blocks.

Step 3: Add Your Data Fields to the Visual

With the new blank chart selected, look at the fields now available under the Visualizations pane. You'll see several buckets to drag your data into:

• Drag your Category column into the Category field well.
• Drag your Value column into the Values field well.

As soon as you do this, Power BI will generate a basic waterfall chart. It will automatically interpret the positive numbers as increases (green bars) and the negative numbers as decreases (red bars). It also adds "Total" columns at the beginning and end, displayed in blue by default.

You can now see the financial story playing out: starting from zero, increasing with revenue, then decreasing with each expense, and ending with a final net total.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Power BI Waterfall Chart

The default chart is functional, but you’ll probably want to tweak its appearance to make it clearer and more professional.

Improving Titles and Labels

With your waterfall chart selected, go to the Format your visual tab (the paintbrush icon) in the Visualizations pane.

• Under General > Title, you can write a more descriptive title, like "Quarterly Profit and Loss Statement."
• Under Data labels, you can turn labels on to see the exact value on top of each bar. This makes the chart easier to read without having to consult the Y-axis.
• Under X-axis and Y-axis, you can adjust font sizes, colors, and disable the axis titles if your chart title is already descriptive enough.

Controlling The Colors

If the default green, red, and blue don't match your company branding or personal preference, you can change them.

In the Format your visual tab, go to Columns. Here, you'll find color pickers for:

• Increase: Sets the color for positive values.
• Decrease: Sets the color for negative values.
• Total: Sets the color for any bars representing a total.

Setting Manual Totals

Sometimes Power BI doesn't create the perfect waterfall flow on its own. For example, in a classic P&L report, "Gross Profit" (Revenue - Cost of Goods Sold) is a significant subtotal. By default, it wouldn't appear as a "total" bar.

To fix this, go back to your source data. Add a row for "Gross Profit" but leave its amount blank or set it to zero. Once you've reloaded the data in Power BI:

1. Go back to your data table view in Power BI.
2. Right-click on the "Gross Profit" row.
3. Select Set as Total.

You can also do this directly in the visual's formatting options. Power BI will now treat that category as a running total - a blue bar summing up all preceding changes - before continuing with the remaining expense flows. This small step can make your financial story much clearer.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using the Breakdown Field

The Breakdown field offers another layer of detail. Let's say your "Marketing Expenses" category consists of several sub-categories like "Paid Ads," "Content Creation," and "Events."

If you have this data, you can drag that sub-category column into the Breakdown field. Now, when your waterfall chart shows the "Marketing Expenses" decrease, it will display it as a stacked bar broken down by these sub-categories, showing you exactly what contributed to that specific cost.

Best Practices & Common Issues

• Sort Your Categories Logically: The power of a waterfall chart comes from its story. Ensure your categories are sorted in a logical sequence. You can set a custom sort order for your Category column in the Data view if needed.
• Simplify with an "Other" Category: If you have dozens of small increases or decreases, your waterfall chart can become cluttered. Consider grouping the smallest items into a single "Other" category to keep the visual clean and focused on major drivers.
• Negative Totals Issue: A common frustration is when the final total is negative. Power BI might display it as a red "decrease" bar instead of a blue "total" bar. The easiest fix is usually to right-click on the final bar in the chart itself and manually select Set as Total.

Final Thoughts

By following these steps, you can create a dynamic and insightful waterfall chart in Power BI. This visual brings your numbers to life, clearly communicating the story behind the data - whether you're tracking performance, analyzing budgets, or explaining financial changes to stakeholders.

We know that mastering tools like Power BI takes time and patience, even for a single chart type. At Graphed, we built a modern alternative where analysis happens in seconds, not hours. Instead of learning where to drag and drop fields or how to format axes, you can connect your data, like Shopify or Google Ads, and just ask, “Create a waterfall chart showing Shopify revenue through to net profit for last month." We turn hours of manual report building into simple conversations so you can get the insights you need and get back to business.