In this article, we show you how to create a Donut chart in Tableau with detailed information. For this Tableau Donut Chart creation, we used the superstore excel file.
Creating a Tableau Donut Chart
First, we created a calculated field with the default name and assigned zero as the value.
Drag that Tableau calculated field multiple times to the rows shelf, which will divide the sheet into two sections. For example, if you observe the Marks section, we have All, SUM(Calculation1), and SUM(Calculation1) section where All belongs to both fields. However, you have the leverage to select the particular calculated field to work with them.
First, select SUM(Calculation2) from the Marks shelf and drag and drop the Category dimension to the colors shelf. And, you can see the Categories for the second field.
Select All (applied to both fields) from the Marks shelf and add Sales measure to Label. By default, the measure aggregated to SUM, and it applied to both sections. So, if you observe the 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.
Let me change the Marks from automatic to Pie chart, which shows two pie charts. The first one is the sum of total sales and the second one is the sales by category.
We have converted these two pie charts 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 chart.
Now, you can see the Donut Chart. But, first, let me change the color of the middle area by increasing the opacity to 100%.
And the final output of the Tableau Donut Chart.
The second approach to create 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 chose the Dual Axis option.
It will instantly create a Tableau Donut Chart.