Tableau Sunburst Chart

This Tableau article shows how to create a sunburst chart using the Dual axis approach, MAKEPOINT function, and map with an example. We used FactInternetSales, DimCustomer, DimGeography, and DimSalesTerritory Tables for this demo.

To create a Tableau Sunburst Chart, right-click the Empty space and select the Create Calculated Field.. option, which 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

Create a Tableau Sunburst Chart

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.

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 the 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 (bottom Zero axis) and choose the Dual Axis option. Now, you can see the Tableau sunburst chart.

Tableau sunburst chart

Formatting

Add Borders to Sales Territory Group in Tableau Sunburst Chart.

Add Borders to Tableau sunburst chart

Add the Sales Amount and Sales Territory Region to the 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

Tableau Sunburst Chart using Maps

This Tableau section shows how to create a sunburst chart using the MAKEPOINT function and maps with an example. We used DimCustomer, DimGeography, DimSalesTerritory, and FactInternetSales Tables for this demo.

Right-click the Empty space and choose the Create Calculated Field.. option will open the following window. Let me rename it and add MAKEPOINT(0, 0) as the value.

Create a calculated Field with MAKEPOINT Function

Double-click on the Makepoint field or add it to the Details shelf to create a Map with auto-generated Latitude and Longitude.

Add MAKEPOINT Function to Details Shelf

Next, change the Markstype from Automatic to Pie Chart. Use Control + Shift + b to increase the size of a circle. Then, add Sales Territory Group to Color and Sum of Sales Amount to Angle shelf.

Pie Chart onTop of a Tableau Sunburst Map

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

Filter the Tableau Sunburst using Maps and MAKEPOINT

Drag and drop the MakePoint field to the Marks Layer to create another Pie.

Add MakePoint field to Marks Layer

You can see the small grey circle in the middle of the Pie chart. Let me rename it as Country and the Pie chart as Group.

Rename the Map Layer and Add Fields to Angle and Color shelf

Choose the Country section and add Sales Territory Group to Color, Sum of Sales Amount to Angle, and Sales Territory Region to Details shelf. Next, convert the Region from Detail to Color.

Further Divide them to Create Tableau Sunburst using Maps and Makepoint

Rearrange layers by dragging Group to the Top, or click the down button and select Move Down. Here, we moved the territory group to the top of the Country and saw the Tableau Sunburst Chart.

Rearrange Mark layers

Edit the Colors of the Sunburst Pie Chart under the Group section.

Format Tableau Sunburst Chart Colors

Drag and drop MakePoint to Marks Layer two times and rename them Inner and Outer Circle. These two help create white color rings.

Add Two more Mark Layers

Drag the Inner Circle Layer in-between the Ground Country, change the mark type to Circle, Color to White, and adjust the size.

Create white color ring or gap between two circles

Change the Outer Circle type to Pie and add Sales to the Label shelf. Next, Click the Label shelf and format the labels.

Add Total Sales in the Middle

Formatting Tableau sunburst Chart Colors

Go to Maps -> Background Maps -> None.

Remove Map Background from Tableau Sunburst Chart using MAKEPOINT

Right-click on the Latitude Axis and uncheck the Show Header option.

uncheck the Show Header

Use the Group Size shelf to change the size of each circle of the Tableau sunburst chart using Maps and Makepoint. Next, format the font and remove the Grid Lines, Zero Lines, and Axis Rulers.

Adjust Size of Tableau Sunburst Chart using Maps & makepoint

Under the Group section, add Sales Amount and Sales Territory Group to the Label shelf. Next, click on Sales to add Quick Table Calculation as the Percentage of Total.

Add Data Labels to Tableau Sunburst Chart using Maps & makepoint

Similarly, add Sales and Territory Group to the Label shelf under the Country section. Next, click on Sales to add Quick Table Calculation as the Percentage of Total for the Tableau Sunburst Chart using Maps.

Add Percentage of Total to Tableau Sunburst Chart using Maps & makepoint