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.
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.
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.
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.
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.
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.
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.
And the final output of this is.
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.
The desktop will instantly create a Donut Chart for you.
