Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Tableau Funnel Chart

Tableau Funnel Chart is useful to visualize the Data in stage-wise. For example, we can use Tableau Funnel Charts to visualize the production cost, Wastage percentage, or the number of resources we used in each stage of our product development.

The Tableau supports two types of Funnel Charts, and they are Traditional and Advanced. This article shows how to Create an advanced Tableau Funnel Chart with an example. For this, we write the Custom Query against the SQL Server.

SELECT Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.[Freight]
FROM DimProduct AS Prod 
   INNER JOIN FactInternetSales AS Fact 
      ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN DimSalesTerritory AS Terry 
      ON Terry.[SalesTerritoryKey] = Fact.[SalesTerritoryKey] 
   INNER JOIN DimGeography AS Geo 
      ON Geo.[SalesTerritoryKey] = Terry.[SalesTerritoryKey]

Create a Tableau Funnel Chart

In this example, we are going to create a Funnel Chart for Country dimension against the Sales Amount size. First, Drag and Drop the Sales Amount from Measures Region to Rows Shelf.

Tableau Funnel Chart 1

Second, Drag and Drop the Country Dimension from Dimension Region to Color Field present inside a Marks Shelf. Please refer to the Traditional Funnel, Connecting Tableau to SQL Server, SQL and Tableau articles.

Tableau Funnel Chart 2

Once you drag them, the following screenshot will be displayed.

Tableau Funnel Chart 3

Third, We have to sort the data in descending order. For this, please click on the Sort by Descending order option in the Tableau Toolbar

Tableau Funnel Chart 4

Next, Drag and Drop the Sales Amount from the Measures Region to Size Field present in Marks Shelf as shown below

Tableau Funnel Chart 5

Once you drag, Desktop will display the Funnel Chart.

Tableau Funnel Chart 6

Add Data Labels to Funnel Chart

Before we finish, Let us add Country Name and Sales Amount as Data labels. To do this, Please drag the Country Name Dimension and Sales Amount from Measures from respective region to Text field in Marks Shelf

Tableau Funnel Chart 7

Now you can see the Country and Sales Amount in the Tableau Funnel Chart

Tableau Funnel Chart 8

Let us add Profit Measure value to the data Label to see the Sales and Profits of each Country

Tableau Funnel Chart 9

Funnel Chart Text Format

To format the Data Labels in Tableau funnel chart, please click on the Text field inside the Marks Shelf. Once you click on it, the following window will be displayed. Click on the … the button beside the Text will open the Edit label window to format the Text

Tableau Funnel Chart 10

Filed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy