Tableau Sunburst Chart using Maps

This Tableau article 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.

Create a Sunburst Chart using Maps in Tableau

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. Please refer to the Calculated Field article in Tableau.

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.

convert the Marks Type from Automatic to Pie

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 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 on Top of the Country.

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. This two help create white color rings.

Add Two more Mark Layers

Drag the Inner Circle Layer in-between the Ground Country, change the Marks 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

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

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