Tableau Funnel Chart

Tableau Funnel Chart is a specialized graph in visualizing the Data in stage-wise. This chart is helpful for users to check the workflow so that they can identify bottlenecks, optimize workflows, and enhance the overall efficiency of production. For example, we can use the Tableau Funnel Charts to visualize the production cost, Wastage percentage, or the number of resources we used in each stage of our product development.

As the name suggests, the Tableau Funnel charts resemble the shape of a funnel with different stages where the values are progressively decreasing from top to bottom. Each section of the Funnel represents each stage, and the width depends on the Measure value, such as orders, sales, production cost, wastage, etc.

Tableau supports two types of Funnel Charts they are Traditional and Advanced. This article shows how to Create traditional and advanced Funnel charts, add data labels, and change funnel colors with an example. For this Tableau Traditional Funnel Chart demo, we use the Custom Query against the SQL Server Data Source.

SELECT Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount
FROM DimProduct AS Prod 
   INNER JOIN FactInternetSales AS Fact 
      ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN DimCustomer AS Cust 
      ON Fact.CustomerKey = Cust.CustomerKey
   INNER JOIN DimGeography AS Geo 
      ON Geo.GeographyKey = Cust.GeographyKey

Traditional Funnel Chart in Tableau

In this example, we will create a Tableau Traditional Funnel Chart against the Sales Amount size for the Country dimension. First, Drag and Drop the Sales Amount from the Measures Region to the Columns Shelf and Country names from the Dimension Region to the Rows Shelf. By default, the desktop will display the Horizontal Bar Chart. For more charts, Click Here.

Add Sales and Country to Create a Bar Chart

As you can see from the above screenshot, the data is sorted country-wise. However, we need the data to sort using sales amount in descending order because the Tableau Funnel chart displays progressively decreasing values from top to bottom.

First, we must sort the Country Names by Sales Amount data in descending order. To do this, click the Toolbar’s Sort by Descending order option. Next, as shown below, we must change the Marks type from Automatic (by default Bar) to Area, and the real magic happens.

Sort the Country in Descending Order and Change Mark Type to Area

Once you complete it, the following screenshot will display. We have finished half (or the right side) of the Tableau traditional funnel chart. We can replicate the sales using the negative symbol to get the other side (left side).

First, create one calculated field for the negative values of the sales amount measure. We can create a calculated field in multiple ways. We are right-clicking the empty space and selecting the Create Calculated Field option from the context menu. Once you select the Create Calculated Field option, a new window will open to create the new calculated field. Let us add the – (SalesAmount) code in that region.

Created a Calculated Field of Negative Sales for the other half of the Tableau Funnel Chart

The following screenshot will show you the newly created calculated field in our measures Region. Drag and Drop the freshly created calculated field (negative Sales) from Measures Region to Columns Shelf. And place it right before the SUM(Sales Amount) Measure. Once complete, you can see the complete Traditional Funnel Chart in Tableau.

Tableau Traditional Funnel Chart

The next step is to combine the Negative Sales and SalesAmount using the Dual Axis option. So, right-click the SalesAmount axis and choose the Dual Axis option from the context menu.

Use Dual Axis option to merge the Left and Right Side the Tableau Funnel Chart

Format Color of a Traditional Funnel Chart in Tableau

The below screenshot shows you the Tableau Traditional funnel chart displaying the Negative Sales and SalesAmount, where the first one represents the red color and the latter one in green.

Tableau Traditional Funnel Chart with Multiple Colors

Although it provides the default colors to Funnel, the desktop allows us to format the Area Color. To change the color, click the Color field inside the Marks Shelf and press the Edit Colors button. Once you click on it, the following window will be displayed. Click on the color you are interested in. We are now selecting the Green Color for the Positive Sales Amount.

The screenshot below will show you the final output, our Traditional Funnel Chart in Tableau.

Format Colors of a Traditional Funnel Chart in Tableau

Add Data Label to Traditional Funnel Chart

Before we finish this Tableau Traditional Funnel Chart, let us add the Sales Amount Measure value as Data labels. To do this, Please drag the Sales Amount from the Measures region to the Label field of the SUM(SalesAmount) Measure in the Marks Shelf.

TIP: If you want to add Data Labels to both Measures, select All Measures in Marks Shelf and Place the Measure value. Otherwise, select the Individual Measure and place the Sales value.

Add Data Labels to Tableau Traditional Funnel Chart

Create an Advanced Tableau Funnel Chart

In this Tableau example, we will create an advanced Funnel Chart to display the Sales Amounts against the Country dimension. Here, the width of each stage depends on the sales. First, Drag and Drop the Sales Amount from the Measures Region to the Rows Shelf. Second, Drag and Drop the Country Dimension from the Dimension Region to the Color Field present inside a Marks Shelf.

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

Add SalesAmount to Rows and Country to Color Shelf

We must sort the data bar in descending order using the sales amount. For this, please click on the Sort by Descending order option in the Toolbar to generate a Tableau Funnel Chart. Next, Drag and Drop the Sales Amount from the Measures Region to the Size Field in the Marks Shelf, as shown below. Once you drag, the Desktop will display the Chart.

Add SalesAmount Measure to Size Shelf

Add Data Labels to Advanced Funnel

We can. use the Label Shelf to add data labels to an Advanced Funnel Chart. So, before we finish the section, let us add the Country Name and Sales Amount as Data labels to the Tableau Funnel Chart. To do this, Please drag the Country Name Dimension and Sales Amount Measure from the respective region to the Text field in the Marks Shelf.

Now, you can see the Country and Sales Amount Data Label in the Funnel Chart.

Add Data Labels to Tableau Advanced Funnel Chart

Click the down arrow beside the SUM(Sales Amount) to select the Quick Table Calculation and click the Percentage of Total to display the percentages in the Funnel Chart.

Tableau Funnel Chart With Percentage as the Data Labels

The following screenshot shows the final preview of the Adnaced Funnel Chart in Tableau with percentages as the data labels.

Tableau Advanced Funnel Chart Preview

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

The third approach to creating a Tableau Funnel Chart

Drag and drop the Country Dimension to the Rows shelf. Next, add the previously created Negative sales calculated field (Negative Sales) and SalesAmount to the Columns shelf.

Add Fields to Rows and Column Shelf

As you can see from the above screenshot, it displays the Tableau Funnel chart. However, we must perform a few steps to get the actual result. First, we have to merge both the negative and actual sales. To do so, within the Columns shelf, click the down arrow beside the sales amount and select the Dual Axis option from the context menu.

Dual Axis to Combine the axis

Please change the Mark type from Automatic (Circle) to Bar to generate the Funnel Chart.

Change the Mark Type from Circle to Bars to create Tableau Funnel Chart

Now you can see the Funnel Chart. Please drag and drop the Sales Amount Measure to the SUM(SalesAmount) marks section to add data labels to the funnel chart’s right side (positive side).

Advanced Tableau Funnel Chart with two Colors

Please add the Country Dimension to the Colors section of the All (combination of SUM(Negative Sales) and SUM(SalesAmount)) Marks type. It will add different colors to each country on the Tableau Funnel Chart.

Advanced Tableau Funnel Chart with Multiple Colors