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.
Double-click on the Makepoint field or add it to the Details shelf to create a Map with auto-generated Latitude and Longitude.
Next, change the Markstype 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.
Add Sales Territory Group to Filters and uncheck the NA from the list.
Drag and drop the MakePoint field to Marks Layer to create another Pie.
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.
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.
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.
Edit the Colors of the Sunburst Pie Chart under the Group section.
Drag and drop MakePoint to Marks Layer two times and rename them Inner and Outer Circle. This two help create white color rings.
Drag the Inner Circle Layer in-between the Ground Country, change the Marks type to Circle, Color to White, and adjust the size.
Change the Outer Circle type to Pie and add Sales to the Label shelf. Next, Click the Label shelf and format the labels.
Go to Maps -> Background Maps -> None.
Right-Click on the Latitude Axis and uncheck the Show Header option.
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.
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.
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.
