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

First, we created a calculated field with the default name and assigned zero as the value.

Calculated field with 0 as calculation

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 aggregated to SUM, and it applied to both sections. So, if you observe the 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 one is the sum of total sales and the second one 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, select the measure and click on the dual axis will do the trick for you. Here, we right-clicked the second Calculation and select the Dual Axis option.

Dual Axis 10

The desktop will instantly create a Donut Chart for you.

Tableau Donut Chart 11