Tableau Sunburst Chart

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.

Create a Calculated Field. Zero

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).

Change the Marks Type to Pie

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.

Pie Chart on two different axis

Use the Size shelf to change or increase the size of a Pie chart.

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.

Add Labels and Calculate Percentage of Total

Select each label and drag them to the middle of each pie for Tableau Sunburst Chart.

Drag Labels to middle of each pie

Drag the Sales Territory Group to the Filters shelf and uncheck the NA from the list.

Apply Filters to Tableau sunburst chart

Adjust the Colors of each pie for Tableau Sunburst Chart.

Change the Colors of each pie

Under the SUM(Zero) section, add Sales Territory Region to the Detail shelf.

Next, click on the Detail icon and change it to Color. 

Sales Territory Region to the Detail shelf and Change it Color

Click the SUM(Zero) Color shelf and match the colors of each Region to the corresponding group.

Change the Colors of the Region

Right-Click the second Axis and choose the Dual Axis option.

Choose Dual Axis

Now, you can see the Tableau sunburst chart.

Tableau sunburst chart

Formatting

Add Borders to Sales Territory Group.

Add Borders to Tableau sunburst chart

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.

Change the Labels to 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.
format to the Tableau sunburst chart