How to Create a Funnel Chart in Tableau with AI

Building a funnel chart in Tableau helps you visualize how users move through a process, like a sales pipeline or a marketing conversion path. It's one of the best ways to spot bottlenecks and find your biggest opportunities for growth. This article will walk you through how to manually build a stepped funnel chart in Tableau, then show you a much faster way to get the same insights using simple questions instead of complex calculations.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is a Funnel Chart, Anyway?

A funnel chart is a visualization that shows the progressive drop-off of values across sequential stages. Think of a real-world funnel - wide at the top and narrow at the bottom. A funnel chart does the same thing with your data, illustrating a flow.

It's incredibly useful for tracking any process where you expect fewer people to complete each subsequent step. Some common examples include:

• E-commerce Conversion: Tracking users from viewing a product page to adding it to their cart, starting checkout, and finally, making a purchase.
• Sales Pipeline: Following leads as they become marketing qualified leads (MQLs), then sales qualified leads (SQLs), opportunities, and ultimately closed-won deals.
• Marketing Campaigns: Measuring how many people saw an ad, clicked on it, landed on your page, and filled out a form.

The main benefit of a funnel chart is its clarity. You can see, at a glance, the biggest leak in your process. For example, if you have 10,000 visitors, 2,000 add an item to their cart, but only 100 complete the purchase, the chart immediately highlights the massive drop-off between cart and purchase, telling you exactly where to focus your optimization efforts.

How to Manually Build a Funnel Chart in Tableau

Tableau is a powerful data visualization tool, but it doesn't have a one-click "Funnel" chart type in its "Show Me" menu. You need to build it yourself using a clever workaround with calculated fields and dual-axis charts. It looks more complicated than it is, so just follow these steps and you’ll be set.

For this example, let's assume we have simple e-commerce data with a column for the Stage (like 'Website Visitors,' 'Viewed Product') and another for the User Count at each stage.

Step 1: Get Your Data Ready

Make sure your data is structured with a dimension for your funnel stages and a measure for the values. It should look something like this:

• Stage: Website Visitors, Viewed Product, Added to Cart, Completed Purchase
• User Count: 50,000, 15,000, 4,000, 1,000

Once your data is loaded into Tableau, you’re ready to start building.

AI for Data Analysis

Crash Course

Graphed

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.

Download Free Guide

Step 2: Create a Calculated Field to Mirror the Funnel

The trick to making a funnel chart in Tableau is to create two bar charts side-by-side that mirror each other, forming a pyramid or funnel shape.

To do this, you need a calculated field that is the negative value of your measure. This will create the left side of your funnel.

1. Go to the top menu and select Analysis > Create Calculated Field.
2. Name this field something like "Negative User Count".
3. In the formula box, simply put a minus sign in front of your measure. It’s that simple.

-[User Count]

Click "OK." You'll now have a new calculated measure in your data pane.

Step 3: Lay Out the Initial Chart

Now, let's put the pieces onto the Tableau canvas.

1. Drag your Stage dimension to the Rows shelf. Your funnel stages should appear listed down the side.
2. Drag your original User Count measure to the Columns shelf. You'll see a standard bar chart.
3. Next, drag your new Negative User Count measure to the Columns shelf, right next to the first measure.

You should now have two bar charts: one growing to the right and one growing to the left from a central point. We’re getting there!

Step 4: Change the Marks to Create the Funnel Shape

Bars aren't quite the right shape for a funnel. Instead, we'll use area charts to get that classic stepped look.

1. In the Marks card pane, you’ll see separate tabs for your two measures ('User Count' and 'Negative User Count').
2. For the first measure, click on its Marks card. Change the dropdown menu from Automatic to Area.
3. Now, do the exact same thing for your 'Negative User Count' measure.

Your bars should now be replaced by solid, filled-in shapes that form a symmetrical funnel.

Step 5: Sort and Label the Funnel Stages

A funnel needs to be in a specific order. Make sure your stages are sorted correctly from the top of the funnel (largest value) to the bottom (smallest value).

1. Right-click the Stage pill on the Rows shelf and select Sort.
2. In the Sort dialog box, choose to sort by a Field, set the "Sort order" to Descending, and select your User Count field as the field name. This ensures the stage with the highest user count is always at the top.

Now, let's add labels so we can see the actual numbers at each stage:

1. From your Data pane, drag the Stage dimension to the Label mark on the "All" tab in the Marks card.
2. Do the same for your original User Count measure, dragging it to Label as well.
3. You may need to adjust the label alignment to make sure the text appears clearly in the center of your funnel. Click the Label mark and navigate through the formatting options.

Step 6: Final Formatting and Cleanup

The core of your funnel is built, but it probably looks a bit busy right now. Let's clean it up to make it more professional.

• Hide the Bottom Axis: You don’t need the numerical axis for the negative measure. Right-click on it (the bottom x-axis) and uncheck Show Header.
• Remove Lines: Go to Format > Lines. Turn off the grid lines and zero lines to give your chart a cleaner background.
• Adjust Colors: Click on the Color mark to change the colors of your funnel segments. You can color-code your stages or use a simple gradient to make it visually appealing.

Don't Just Show Drop-Offs, Calculate Conversion Rates

A funnel chart is great for seeing drop-offs, but the real power comes from quantifying them. You want to know the conversion rate – the percentage of users who move from one stage to the next. You can add this directly to your labels in Tableau using a Quick Table Calculation.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Calculating Step-By-Step Conversion

Let's add a label that shows the percentage decrease from the previous stage. This immediately tells you where your biggest percentage leak is located.

1. Drag your main measure (e.g., User Count) to the Label mark again. You should now see the count twice.
2. Right-click on the new pill you just added to the Marks card.
3. Select Quick Table Calculation > Percent Difference.
4. By default, this calculates the difference relative to the previous row, which is exactly what we want for a funnel.

You'll now see labels showing you both the raw number of users and the percent drop-off at each stage (e.g., "From 'Viewed Product' to 'Added to Cart,' we lost 73% of users."). Now that's an actionable insight.

A Faster Way: How AI Changes Funnel Creation

Okay, take a breath. The manual process works, but as you can see, it involves calculated fields, dual axes, formatting adjustments, and table calculations. It’s a great skill to have, but it’s not exactly fast. And if a teammate asks you to show the same funnel but only for mobile users or for a specific product category, you're back to clicking, filtering, and adjusting.

This is where modern AI-powered data tools come in. They flip the script entirely. Instead of you needing to know how to build the chart, you just need to know how to ask for it.

The Challenge with Manual Reporting

Building reports manually, especially on a regular basis, is incredibly time-consuming. For many marketing and sales teams, the cycle is brutal: spend Monday downloading CSVs, wrangle them in a spreadsheet, build the charts in a BI tool, present them on Tuesday, and spend Wednesday handling all the follow-up questions from the meeting. By the time you've produced the insights, half the week is gone, and the moment to act may have already passed.

This process also assumes you have the technical skills to build complex visualizations in the first place, gatekeeping insights from non-technical team members who actually need them to do their jobs.

AI for Data Analysis

Crash Course

Graphed

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.

Download Free Guide

Using Natural Language to Create Reports

Instead of the 20-click process outlined above, AI data platforms allow you to create the same funnel chart with a single sentence.

Imagine just typing a prompt like:

"Build a funnel chart showing our e-commerce flow from website visitors, to product viewers, cart additions, and purchases over the last 90 days."

The system understands your request, queries the underlying data, creates the necessary calculations automatically, and generates a fully interactive funnel chart in seconds. You don't need to know about "negative measure calculated fields" or "quick table calculations" – you just ask your question in plain English.

The Real Power is in Follow-Up Questions

The biggest advantage of this approach isn’t just the initial speed, it’s the ability to explore your data conversationally. Once your funnel chart is up, you can drill down instantly:

• "Okay, show me this funnel for mobile users only."
• "Which marketing channel drives the highest conversion from Add to Cart to Purchase?"
• "What does this trend look like compared to last quarter?"

Each question gets an immediate answer, updating the visualization without you needing to find the right filter or manually create another chart from scratch. This allows a much deeper, faster, and more intuitive exploration of your data, transforming your role from a report builder to an insight finder.

Final Thoughts

Whether you're manually crafting a stepped chart in Tableau or leveraging newer AI-driven tools, the objective is the same: to clearly visualize a user journey and pinpoint opportunities for improvement. Understanding how to build a funnel chart is an empowering skill that puts you in control of your data narrative.

While mastering tools like Tableau is invaluable, we created Graphed for the marketers, founders, and sales leaders who need answers faster than a manual process allows. There’s no need to spend time learning complex tools or waiting for data teams. We let you connect your data sources like Google Analytics, Shopify, and Salesforce, then simply ask for what you need in plain English. Prompt something like, "create a full sales dashboard comparing performance across our reps this month," and Graphed generates a live, shareable dashboard in seconds. This turns hours of report building into a 30-second conversation, giving you more time to act on your insights.