This Tableau article shows how to create a sunburst chart using the Dual axis approach with an example. We used FactInternetSales, DimCustomer, DimGeography, and DimSalesTerritory Tables for this demo.
Create a Tableau Sunburst Chart
Right-click the Empty space and select the Create Calculated Field.. option will open the below-shown window. Let me rename it as Zero and 0 as the value. Then, please refer to the Calculated Field article in Tableau.
Add the Zero calculated field twice to the Rows shelf, and change the Marks from Automatic to Pie Chart. Remember to change the All section; otherwise, change Marks for both SUM(Zero) and SUM(Zero)(2).
Choose an individual section of SUM(Zero) and SUM(Zero)(2) and add Sales Territory Group to the Color shelf and Sum of Sales Amount to Angle.
Use the Size shelf to change or increase the size of a Pie chart.
Under the SUM(Zero)(2) section, add Sales Amount and Territory Group to the Label shelf. Next, click on Sales to add Quick Table Calculation as the Percentage of Total.
Select each label and drag them to the middle of each pie for Tableau Sunburst Chart.
Drag the Sales Territory Group to the Filters shelf and uncheck the NA from the list.
Adjust the Colors of each pie for Tableau Sunburst Chart.
Under the SUM(Zero) section, add Sales Territory Region to the Detail shelf.
Next, click on the Detail icon and change it to Color.
Click the SUM(Zero) Color shelf and match the colors of each Region to the corresponding group.
Right-Click the second Axis and choose the Dual Axis option.
Now, you can see the Tableau sunburst chart.
Formatting
Add Borders to Sales Territory Group.
Add the Sales Amount and Sales Territory Region to SUM(Zero) Label shelf. Next, click on Sales to add Quick Table Calculation as the Percentage of Total.
Let me do some quick formatting to the Tableau sunburst chart.
- Right-Click on the Zero Axis and uncheck the Show Header option.
- Go to Formatting Menu -> Format Lines -> Set Zero Lines to None.
- Click the A button and change the Font of a Worksheet.
- Double-click the Tooltip under the All section and remove the Zero from the Tooltip.
