How to Make a Funnel in Tableau

Funnel charts are one of the most effective ways to visualize drop-offs in a marketing or sales process. While Tableau is an incredibly powerful tool, creating a visually clean and informative funnel chart isn’t as straightforward as just selecting a chart type. This guide will walk you through a step-by-step process for building a powerful funnel chart from scratch, so you can clearly see where you’re losing customers or leads.

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 Exactly is a Funnel Chart?

Think of a funnel chart as a way to show how an initial number of people narrows down through a series of steps. It gets its name from its shape, which is wide at the top and narrow at the bottom, just like a real-world funnel. Marketers and sales teams use them constantly to track processes like:

• Website conversions: From website visitors to sign-ups, to creating a profile, to final purchase.
• Sales pipeline: From initial leads to qualified leads, to meetings scheduled, to deals won.
• Email marketing campaigns: From emails sent to emails opened, to links clicked, and finally to conversions.

The main job of a funnel chart is to flag the biggest drop-offs in your process. If you go from 10,000 website visitors to only 500 product sign-ups, that first step is where you have the biggest opportunity for improvement. Seeing this visually is much more impactful than looking at numbers in a spreadsheet.

First, Let's Prepare Your Data

Before you open Tableau, a little data preparation will make your life much easier. For a standard funnel chart, you really only need two main columns:

1. A "Stage" column (Dimension): This lists the different sequential steps in your funnel (e.g., "Awareness," "Consideration," "Purchase").
2. A "Count" column (Measure): This contains the number of people, users, or deals at each stage (e.g., 50,000, 10,000, 1,500).

Your data could look as simple as this:

Stage,Users
"Site Visitors",52340
"Added to Cart",8750
"Reached Checkout",4120
"Completed Purchase",2890

The most important thing to get right is the order of your stages. Your funnel needs to flow logically from top to bottom. If your stages are out of order, the chart won’t make sense.

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

A Step-by-Step Guide to Creating Your Funnel Chart in Tableau

Once you have your data connected, we can start building. We're going to use a clever technique that involves creating a symmetrical chart to achieve the classic funnel shape.

Step 1: Build the Initial Bar Chart

To start, create a simple horizontal bar chart. This will serve as the foundation for your funnel.

• Drag your "Stage" dimension to the Rows shelf.
• Drag your "Users" (or count) measure to the Columns shelf.

You should see a basic bar chart. Now, sort your stages so they are in the correct top-to-bottom funnel order. You can do this by dragging the stage names in the view or by right-clicking the "Stage" pill in the Rows shelf and setting a custom sort order.

Step 2: Create the Symmetrical Shape

Here's where the magic happens. The trick to creating the centered funnel shape in Tableau is to build a mirror image of your bar chart. We do this by creating a calculated field that turns your measure into a negative number.

1. Go to Analysis > Create Calculated Field.
2. Name the field something like "Negative Users".
3. Enter the formula: -SUM([Users])
4. Click OK.

Now, drag this new "Negative Users" calculated field to the Columns shelf, next to your original SUM(Users) pill. You'll now have two charts side-by-side: one going right and one going left.

Step 3: Change the Mark Type to Area

To get the sloping sides of the funnel, we'll change the chart type from bars to an area chart.

• Go to the Marks card. If you see only one card, that means you're controlling both charts at once. If you see cards for SUM(Users) and "Negative Users," you’ll need to adjust each one.
• Click the dropdown menu that currently says Automatic and select Area.

Instantly, your two mirrored bar charts will transform into the recognizable tapered shape of a funnel. You’re getting close!

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 4: Clean it Up and Add Labels

Your chart now has the right shape, but it needs some formatting to be readable and professional. Let’s clean it up.

• Hide the Negative Axis: You don't need to show an axis with negative numbers. Right-click on the top axis (for your negative measure) and uncheck Show Header.
• Add Your Data Labels: Clear labels turn a chart from a shape into a source of information.

Step 5: Calculate and Display Conversion Rates

The true power of a funnel chart comes from understanding the conversion rate between steps. Showing the percentage drop-off adds critical context. Here's how to calculate and add it.

1. On the Marks card for your SUM(Users), drag another copy of your "Users" measure onto the Label shelf.
2. Right-click on this new pill and select Quick Table Calculation > Percent of Total. It will now show the percentage breakdown.
3. For an even better insight—the conversion rate from the previous step—you’ll use a different calculation. Right-click the same pill again, select Edit Table Calculation, and then change the calculation type to Percent From, relative to the Previous value.

Now, click on the Label shelf and use the text editor (...) to arrange your labels neatly. For example, you can put the stage name on the first line, the absolute number on the second, and the conversion percentage on the third. Now your funnel chart tells a complete story.

Common Stumbling Blocks (and Their Fixes)

Building funnel charts in Tableau can sometimes feel a bit tricky. Here are a couple of issues you might run into and how to quickly solve them.

Stages Are in the Wrong Order

The problem: Your funnel doesn't taper correctly because the steps ("Site Visitors," "Purchase," "Added to Cart") are sorted alphabetically or randomly.

How to fix it: Right-click your "Stage" dimension in the Dimensions pane on the left. Go to Default Properties > Sort. From there, choose Manual sort and drag the items into the correct logical order for your funnel. Click OK, and your chart will update correctly.

Labels Overlap and Look Messy

The problem: Your numbers and stage names are crammed on top of each other, especially in the narrower parts of the funnel.

How to fix it: Click on the Label shelf on the Marks card. From there, you have a few options: try different vertical and horizontal alignment settings, slightly reduce the font size, or edit the text itself to make it more compact. For very narrow stages, sometimes it's best to only show the number and rely on the tooltip to provide the rest of the information.

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

Your Funnel Looks Like A Triangle

The problem: Your chart is a perfectly straight-sided triangle instead of a tapered funnel showing distinct stages.

How to fix it: Be sure your mark type is set to Area and that your "Stage" dimension is on the Rows shelf. Path, Detail, or Color can also impact final output as dimensions.

Final Thoughts

Building a quality funnel chart in Tableau is an excellent way to turn your raw conversion data into a powerful visual story. By creating a symmetric chart using a negative-value calculated field and converting it to an area chart, you gain complete control over your funnel’s appearance and get a clear picture of what's happening at each stage of your conversion path.

While the process in Tableau is very flexible, it still requires creating calculated fields, wrestling with labels, and working through several steps to get an output. It’s that very process that inspired us to simplify reporting. That’s why we built Graphed for handling an organization’s dashboards and reports for them. After connecting your data sources in a few clicks, you can ask for a report in simple, natural language—like, “create a funnel diagram that shows Canada-specific traffic against all traffic,” or, “show me sales funnel by each account owner”—and receive a real-time, interactive dashboard in seconds. This allows you to skip straight to analyzing insights, not getting bogged down in tool setup and configuration.