Tableau Donut Chart

In this article, we show you how to create a Donut chart in Tableau with detailed information. For this creation, we used the superstore excel file.

Create a Donut Chart in Tableau

Before we started creating a Tableau Donut Chart, we first created a calculated field with the default name and assigned zero as the value.

Calculated field with 0 as calculation

Tableau Donut Chart video

Drag that Tableau calculated field multiple times to the rows shelf. This calculated field will divide the sheet into two sections.

For example, if you observe the Tableau Donut Chart Marks card section, we have All, SUM(Calculation1), and SUM(Calculation1) sections where All belongs to both fields. However, you have the leverage to select the particular calculated field to work with them.

Dropping Zero Calculation on to Rows Shelf

First, select SUM(Calculation2) from the Marks card shelf and drag and drop the Category dimension to the colors shelf. And you can see the Categories for the second field.

dimension Field on Categories

Select All (applied to both fields) from the Marks card and add Sales measure to Label. By default, the measure is aggregated to SUM and applied to both sections. So, if you observe the Tableau Donut Chart sheet, it shows the sum of sales in the first half. However, we need to work a bit to show it in the second section.

Multiple Axis

Let me change the Marks card from automatic to Piechart, which shows two pie charts. The first is the sum of total sales, and the second is the sales by category.

Two Pie Charts to create a Tableau donut chart

We have converted these two pie plots into a Tableau donut chart. For this, select the second SUM(Calculation1) from the marks shelf and increase the Detail or zoom it will create a donut.

Convert Two Pies to Donut

Now, you can see the actual donut chart. But first, let me change the color of the middle area by increasing the opacity to 100% to improve your experience.

Tableau Donut Chart 8

And the final output of this is.

Donut Chart 9

The second approach to creating a Tableau Donut Chart involves the dual axis. Instead of increasing the details, selecting the measure and clicking on the dual axis will do the trick for you. Here, we right-clicked the second Calculation and selected the Dual Axis option.

Dual Axis 10

The desktop will instantly create a Donut Chart for you.

Tableau Donut Chart 11

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.