How to Make a Waterfall Chart in Tableau with AI
A waterfall chart is one of the best ways to tell a financial story, visualize the impact of positive and negative changes, or show how you got from a starting value to an ending one. While making one in Tableau used to feel like a secret handshake for seasoned analysts, it’s now more accessible than ever. This guide will walk you through building a waterfall chart in Tableau step-by-step and explain how new AI features can make the process even faster.
What is a Waterfall Chart, Exactly?
Imagine you're explaining your company's monthly profit. You started with your total revenue, then subtracted costs for goods sold, marketing expenses, and salaries until you reached your final net profit. A waterfall chart visualizes that exact story. It plots a running total, showing how individual positive contributions (like revenue) and negative contributions (like expenses) add up over time.
They’re incredibly useful for:
- Visualizing a Profit and Loss (P&L) Statement: The classic example, showing the journey from revenue to net income.
- Tracking Inventory Changes: Starting inventory + purchases - sales = ending inventory.
- Analyzing Sales Pipeline Changes: Starting leads + new leads - disqualified leads - lost deals = closed wins.
- Explaining Budget Variances: Starting budget vs. actual spend across different departments.
Essentially, anytime you need to explain the "ups and downs" that contribute to a final result, a waterfall chart is the perfect tool for the job.
How to Build a Waterfall Chart in Tableau
Building a waterfall chart in Tableau requires a clever combination of a running total calculation and changing the mark type to a Gantt Bar. It might seem a little unusual at first, but once you do it once, the logic clicks into place. Let’s build one to show a simplified profit and loss statement.
First, make sure your data is structured with a dimension for your categories (e.g., 'Revenue', 'COGS', 'Marketing Spend') and a measure for the value of the change (e.g., a 'Profit/Loss' column where expenses are negative numbers).
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Step 1: Create the Initial Bar Chart
To start, connect to your data source in Tableau. Drag your category dimension onto the Columns shelf and your measure onto the Rows shelf. You'll get a standard bar chart showing the value for each category.
For our P&L example, you'd put 'Category' on Columns and 'Amount' on Rows. Revenue will be a positive bar, while COGS and Marketing will be negative bars.
Step 2: Apply a Running Total Calculation
This is where the magic begins. A waterfall chart is a running total, so we need Tableau to calculate that for us.
- Right-click the measure pill on the Rows shelf (e.g.,
SUM(Amount)). - Select Quick Table Calculation > Running Total.
Your chart will now change to show a running accumulation. Revenue will be the first point, then COGS will bring the next point down, Marketing will bring it down further, and so on.
Step 3: Change the Mark Type to a Gantt Bar
Next, we will change the visual representation from bars to a Gantt mark. A Gantt Bar mark needs a starting point and a size to draw itself. The "Running Total" calculation we just created is the starting point for each bar.
- In the Marks card dropdown, change the selection from 'Automatic' or 'Bar' to Gantt Bar.
Your view will probably look a little strange — just a series of disconnected lines or dashes. That's because we've told Tableau where each Gantt mark should start (the running total), but not how big it should be. We fix that in the next step.
Step 4: Create a 'Bar Size' Calculated Field
We need to tell Tableau how long each floating bar should be. The length of each bar is simply the positive or negative value of that category's measure. We'll create a calculated field to control this, but with a twist — we need to make it a negative value to get the bars to draw correctly on the axis.
- Click the dropdown arrow at the top of the Data pane and select Create Calculated Field.
- Name the field something like "Bar Size".
- Enter the formula to be the negative of your measure. For example:
- [Amount]. - Click OK.
Now, drag your new Bar Size calculated field from the Data pane onto the Size shelf on the Marks card. Your waterfall chart will instantly appear! Each bar now has a size corresponding to its value, creating the classic "floating brick" look.
Step 5: Color the Bars for Clarity
A good waterfall chart uses color to instantly show the difference between positive and negative changes. Let's create another calculated field for that.
- Create a new calculated field and name it Direction.
- Use a simple IF statement to classify the bars:
IF SUM([Amount]) > 0 THEN "Increase"
ELSE "Decrease"
END- Click OK.
- Drag the new Direction field onto the Color shelf on the Marks card.
Tableau will assign default colors. You can click the Color shelf to edit them — typically green for increases and red for decreases works great.
Step 6: Add Grand Totals
Most waterfall charts include beginning and ending total bars to frame the analysis. Tableau can add a final totals bar easily.
- From the top menu, go to Analysis > Totals > Show Row Grand Totals.
A "Grand Total" bar will appear at the end, representing the final net value. You can format this bar to extend to the zero line by creating an additional data entry for "Net Income" where the 'Bar Size' calculation is adjusted, but for most use cases, the default total works well.
Accelerating Creation with Tableau's AI Features
While mastering the manual steps gives you a deep understanding of how Tableau works, you don't always have to build your charts from scratch. Tableau's integrated AI, branded as Einstein Copilot, is fundamentally changing the workflow from a series of clicks to a simple conversation.
Using Einstein Copilot and Ask Data to Build Charts
Instead of dragging and dropping pills and creating calculated fields manually, you can use plain English to describe the chart you want. Within the Tableau environment, you can use features like Ask Data or the Copilot interface to submit a prompt.
You could type something like:
"Create a waterfall chart of the amount by category showing the running total."
Tableau's AI will parse your request and attempt to build the chart for you. It understands terms like "waterfall chart" and "running total" and will perform many of the steps we just went through — applying the table calculation, changing the mark type, and placing fields on the correct shelves — automatically.
The real benefit here is speed. An analyst who knows what they're doing can do this in minutes. But with an AI prompt, you can get a functional first draft in seconds. This allows you to get to the insight faster and spend more time refining the visual story rather than getting bogged down in the technical setup.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Brainstorming and Data Exploration
AI also helps with the step before you even build the chart. You can ask exploratory questions to get a better handle on your data. For example, before you even commit to building a P&L waterfall chart, you could ask:
"What are my biggest expenses after COGS?"
Tableau's natural language processing can give you a quick answer, helping you decide which categories are most important to include in your visualization. It lowers the barrier for less technical team members, allowing anyone to have a conversation with their data without needing to know the difference between a dimension and a measure.
Final Thoughts
Waterfall charts are a compelling analytics tool that can visually break down complex changes into an easy-to-understand story. By learning the Gantt Bar method in Tableau, you gain the power to build them from scratch, while leveraging features like Einstein Copilot helps you get there in a fraction of the time.
Even with these powerful tools, many marketing and sales teams still lose half their week manually downloading CSVs from different platforms like Google Analytics, Shopify, and Salesforce to unify the data before analysis can even begin. We created Graphed to simplify this entire process. Instead of complex setup or manual data wrangling, you can connect your sources once and just ask in plain English, "Show me a dashboard of my marketing funnel," and get a live, automated report in seconds, not hours.
Related Articles
Facebook Ads for Gyms: The Complete 2026 Strategy Guide
Master Facebook advertising for your gym in 2026. Learn the proven 6-section framework, targeting strategies, and ad formats that drive memberships.
Facebook Ads for Home Cleaners: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for home cleaners in 2026. Discover the best ad formats, targeting strategies, and budgeting tips to generate more leads.
Facebook Ads for Pet Grooming: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for pet grooming businesses in 2025. Discover AI-powered creative scaling, pain point discovery strategies, and the new customer offer that works.