Practical Tableau: How to Make Funnel Charts

1. Create a horizontal bar chart by dragging your step dimension onto the rows shelf and your players measure to the rows shelf.

2. The next step is where the magic happens. Simply change the mark type from ‘Automatic’ (which is currently ‘Bar’) to ‘Area’. You are left  with the right side of the funnel.

3. If your data is in a format outlined in the table above, there is a simple solution to mirroring the right side of the funnel onto the left side. To do this, you will create a calculated field by right-clicking on the ‘Players’ measure and selecting ‘Create Calculated Field’. Name your calculated field ‘Negative Players’ and add a ‘-‘ in front of ‘[Players]’. Your entire formula will look like this:

4. The final step in creating a symmetrical funnel chart is to drag and drop your new ‘Negative Players’ measure in front of the ‘Players’ measure on the columns shelf.

From here, your funnel chart can be used like any other chart in Tableau. Encode it by color (in my case, its colored by gender), add quick filters, and add tooltips / labels / annotations to make the data in the chart clear to the end user.

Using separate measures to create Tableau funnel charts

It is likely that your corporate data is not in the layout of the table above by default, and you may not be in a position to easily change this on your own. This solution is not as flexible or optimal for Tableau, but it is functional. Let’s assume that instead of the layout in the table above, your data looks more like this, with each ‘Players’ measure broken out by level, causing your layout to be more horizontal instead of vertical:

In this case, because you no longer have a dimension of step, the approach is slightly different:

1. To create the right side of the funnel, you will need to add the measures to the view individually. The easiest way to do this is to double click each of your three measures (Step 1 Players, Step 2 Players, and Step 3 Players) to add them to the view. Double-clicking each measure will create a small multiples chart, so you will have to use the ‘Show Me’ button to change the chart type to a bar chart. While the set-up is different, you should now see the beginnings of the right side of your funnel, just like in step one from the first approach above:

2. Follow Step 2 from the first approach, changing your mark type from ‘Automatic’ to ‘Area’.

3. Step 3 on the second approach is where things get tricky. The first thing you need to do is create a negative version of each of your three measures, much like creating a negative version of the ‘Players’ measure in step three from the first approach. Once you have three new calculated fields, one negative version for each of your three measures (i.e. Negative Step 1 Players, Negative Step 2 Players, and Negative Step 3 Players), open a new worksheet and follow steps one and two from above – this time using your newly created negative versions of each measure. You should end up with the left side of your funnel:

4. The final step to this approach is joining the left and right side of your funnel. This can be accomplished by floating each sheet on a dashboard and lining them up:

Admittedly, this second approach requires some hackish creativity, but it works with most data out of box without any reformatting.

So there you have it! Funnel charts in four simple steps, regardless of the layout of your funnel data.

Thanks for reading,
– Ryan