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.
Tableau supports two types of Funnel Charts: Traditional and Advanced. This article shows how to Create an advanced Tableau Funnel Chart with an example. For this, we are going to write the Custom SQL Query against the SQL Server. So, please visit Connecting Tableau to SQL Server to know the configurations.
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 as shown below
Second, Drag and Drop the Country Dimension from Dimension Region to Color Field present inside a Marks Shelf
Once you drag them, the following screenshot will be displayed.
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
Next, Drag and Drop the Sales Amount from the Measures Region to Size Field present in Marks Shelf as shown below
Once you drag, Desktop will display the Funnel Chart as shown in the below screenshot
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 and drop the Country Name Dimension and Sales Amount from Measures from respective region to Text field in Marks Shelf
Now you can see the Country and Sales Amount in the Tableau Funnel Chart
Let us add Profit Measure value to the data Label to see the Sales and Profits of each Country
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