Tableau

How to create a sunburst chart in Tableau

The sunburst chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring with the innermost circle as the top of the hierarchy.

Let us then see how to build step-by-step a sunburst chart on Tableau. Our goal is to create a graph showing sales for each category, sub category and manufacturer from Sample Superstore data.

Step 1. Create the chart

  1. Connect to the data source Sample – Superstore.
  2. Create a calculated field. Let’s call it Location and type MAKEPOINT(0,0).
  3. Drag Location on the view.
  4. Drag Location in the top left corner of the view and drop it on Marks Layer as shown below. Repeat this until you have 4 Marks cards.

  1. Drag away Longitude and Latitude from Columns and Rows.
  2. Select the Marks card Location (4). Select Circle in the dropdown menu and choose the color White from Color. Reduce the size a little as well.
  3. Fit to Entire view.
  4. Select the Marks card Location (3). Drag Product on Color.
  5. Select Pie from the dropdown menu in the Marks card Location (3). Drag Sales on Angle.

  1. Select the Marks card Location (2). Drag Product on Color and select Pie from the dropdown menu. Drag Sales on Angle.
  2. On Marks card Location (2) adjust the size to make it a bit bigger.
  3. On Marks card Location (2) click on the + sign next to Category as shown below in the black circle. A new tab Sub-category will appear.

  1. Now click next to Sub-category and select Color as shown below.

  1. This is what you should get!

  1. Select the Marks card Location. Drag Product on Color. Select Pie from the dropdown menu.
  2. Click the + sign next to Category so that Sub-category appears as in point 12. Click the + sign next to Sub-category so that Manufacturer appears.
  3. Click where the blue circles are and select Color.

 

 

 

  1. Adjust the size from Marks card Location to make it bigger.
  2. Click on Color in the Marks card Location and select the color white for Border.

  1. Drag Sales to Angle in the Marks card Location.
  2. Go on Marks card 2 and 3 and repeat what you did in point 19.
  3. Select Edit color as in the picture below and change the color of Technology to green.

  1. Done!

Don’t wait! Contact us to learn more and continue to follow upcoming news on our website and LinkedIn channel.