How to Make a Waterfall Chart in Power BI with AI

Creating a waterfall chart in Power BI is one of the best ways to tell a clear story about how your numbers change over time. This article will show you exactly how to build one, step by step, and introduce how you can use AI to build them almost instantly.

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?

A waterfall chart visualizes how a starting value increases or decreases through a series of positive and negative changes to reach a final value. Think of it as telling the financial story of your month. You start with your opening bank balance, then show bars for money coming in (sales, investments) and money going out (salaries, rent, marketing spend) to arrive at your closing balance.

This visual is incredibly useful for contexts like:

• Financial Statements: Showing how revenue translates to net profit after accounting for costs and expenses.
• Inventory Tracking: Starting with initial stock, adding new inventory, subtracting sales and returns, and ending with the final stock count.
• Sales Pipeline: Visualizing the flow of leads from one stage to the next, from initial contact to a closed deal.

Essentially, any time you need to explain the "journey" of a metric - what added to it and what took away from it - a waterfall chart is an excellent choice.

Getting Your Data Ready

Before you build the chart, your data needs to be structured in a simple way. Power BI is smart, but it needs a little help to understand your story. You typically need at least two columns:

• A Category Column: This is a text field that labels each step of the journey (e.g., "Starting Revenue," "New Sales," "Customer Churn," "Marketing Costs," "Ending Revenue").
• A Value Column: This is a numerical field that holds the amount for each category. Positive numbers represent increases, and negative numbers represent decreases.

For example, your data might look like this in a spreadsheet before importing it into Power BI:

With data like this, Power BI can easily plot the increases and decreases to tell the story of your revenue changes.

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

How to Build a Waterfall Chart in Power BI (Manually)

Let's start with the traditional click-by-click method. This gives you a solid foundation for understanding how the visual works before we introduce the AI shortcuts.

1. Load Your Data: Open Power BI Desktop. On the Home ribbon, click Get Data and select the source of your data (e.g., Excel workbook, SQL Server). Find your file and load the appropriate table into your model.
2. Select the Waterfall Visual: In the Visualizations pane on the right-hand side, find and click the waterfall chart icon. It looks like a series of floating bars. This will add a blank chart template to your report canvas.
3. Populate the Fields: With the blank chart selected, you'll see fields in the Visualizations pane like Category, Y Axis, and Breakdown.
4. See It Come to Life: As soon as you drop the fields in, Power BI will automatically render the chart. It interprets positive values as "Increase" (typically green) and negative values as "Decrease" (typically red). It will automatically calculate and display a final "Total" bar. Your chart showing the flow from "Initial Revenue" to the final calculated amount will appear. You might want to add a final row to your data called "Final Revenue" - or you could create a measure to act as your final revenue to keep it dynamic.

Now that the chart exists, you can head over to the Format your visual tab (the paintbrush icon) in the Visualizations pane to customize colors, data labels, the title, and more.

Unlocking AI: Creating a Waterfall Chart with Power BI Copilot

If your organization has Copilot for Microsoft Fabric enabled, you can skip most of the manual steps above. Power BI's AI assistant, Copilot, can build visuals for you based on simple, plain-English instructions. This feature dramatically speeds up the report-building process, especially for those who aren't familiar with every panel and option in Power BI.

Three Steps To Your AI-Created Chart:

1. Activate Copilot: First, ensure you've loaded your data into Power BI just like in the manual method. Then you'll see a Copilot button in the ribbon menu. Click this to open the Copilot chat pane.
2. Prompt The AI: With your data model in place, you can simply request a report from Copilot - or even easier, prompt Copilot to produce a single chart on the existing page: "Create a waterfall chart showing total revenue."
3. Give More Complex Prompts: After iterating or getting better at prompting, you could provide an explicit prompt like: "Create a waterfall chart using the 'Category' and 'Amount' columns." Within seconds, Copilot will analyze your request, identify the relevant data, and place a fully configured waterfall chart onto your report canvas.

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

Example Prompts for Copilot

The real power of AI is its ability to understand your intent. You don't always need to know the exact column names. Here are a few different prompts you could try:

• "Show me the change in Q1 revenue as a waterfall chart."
• "Generate a waterfall breaking down our March financials from revenue to net income."
• "Visualize our sales team headcount changes for last year, including new hires and departures."

Copilot makes a best guess based on your data model. If it gets something slightly wrong - say, it chose the wrong category field - you can either tweak it manually or refine your prompt: "Remake that but use the 'Deal Stage' column for the breakdown."

Fine-Tuning Your AI-Generated Chart

Copilot excels at getting you a solid draft in record time, but you'll likely want to make some final tweaks to match your company's branding or to highlight certain data points.

Once Copilot creates the chart, just click on it. All the same customization options become available in the Format your visual pane. You can:

• Adjust Sentiment Colors: Change the default green for Increase, red for Decrease, and blue for Total to match your brand's color palette.
• Refine Data Labels: Add or remove the actual numerical values that appear on each column to make the chart cleaner or more detailed.
• Update the Title: Copilot will generate a title based on your prompt, but you can easily edit it to be more specific or descriptive. For example, "Q1 Recurring Revenue Walk-Through."
• Configure the Y-Axis: Adjust the scale, add a title like "Amount (in USD)," or switch to a logarithmic scale if your numbers have a huge range.

Beyond the Chart: Ask AI Follow-Up Questions

A static chart is good, but immediate answers are better. Power BI's AI features work together to help you dig deeper. After your waterfall chart is created, you can use other AI visuals, like the Q&A (Questions & Answers) feature, to explore further.

For example, if you see a large drop in the "Cancellations (Churn)" bar on your waterfall chart, you could ask the Q&A visual a follow-up question like: "Which product plan had the highest cancellations last month?"

This transforms your dashboard from a simple static report into an interactive analytical tool, allowing anyone on your team to drill down and understand the "why" behind the numbers without needing to build new visuals from scratch.

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

Final Thoughts

Waterfall charts are fantastic storytelling tools for illustrating financial and operational changes. With Power BI, building them has become more accessible than ever, and with the integration of AI tools like Copilot, you can now create them faster than you can grab a cup of coffee.

While tools like Power BI are incredibly powerful, they can still present a steep learning curve with their countless menus and configuration options. At Graphed , we’ve focused on taking the AI-first approach to an even simpler and more intuitive level. Instead of navigating a complex interface, we let you just connect your data sources - like Google Analytics, HubSpot, Shopify, and Quickbooks - and create entire dashboards using simple, conversational prompts. It's like having a dedicated data analyst you can chat with, who builds your live charts and dashboards in real-time without you ever having to click and drag fields around to do manual analysis again.