A Semi-Sunburst chart in Tableau creates a visually striking effect that catches the viewer’s attention. If you need to add a secret weapon to a dashboard full of tables and bar charts, this is a great element to incorporate. The compact layout displays the detailed distribution of a positive measure across two dimensions within a small space. While it isn’t the best tool for accurate estimation, it pairs well with a simple list or table. Together, they provide a high-impact summary of the data along with a straightforward list of exact values.

Final Image

View / Interact / Download

 

How the Semi-Sunburst chart in Tableau works

This dashboard uses four worksheets. The first worksheet holds the innermost donut chart, which is built on a ‘placeholder’ axis manually set to show just half of the donut. This sheet is layered over the second worksheet, which holds a larger donut chart. Together, these two worksheets are assembled into a semi-sunburst chart in Tableau. A third worksheet next to the half pie lists exact totals. Finally, a fourth hidden sheet is used as a viz in tooltip. 

Thumbnails

Create a free account, or login.

Unlock this tutorial and hundreds of other free visual analytics resources from our expert team.

Already have an account? Sign In

Name
Password
This field is for validation purposes and should be left unchanged.

Explore unlimited access to all offerings.

See membership options.

 

Creating a Donut chart

Start with a standard pie chart, using the dimension you’ll want in the inner layer. In this example, I’ve used Category for color and Quantity for angle.

Donut charts require two Marks cards, so we’ll need a placeholder axis. I used the calculation MIN(0) and named it “Placeholder Axis”. 

3 Innovative Ways to Use Tableau Scaffolding

Placeholder Axis

Add the Placeholder Axis field to the Columns shelf, then add a second copy of the same field to create a second axis and Marks card. The second Marks card will form the hole of the donut. Remove all dimensions and measures from the second Marks card, change the color to white, and reduce the size. 

New to Playfair Data?

Watch our 90-second intro video and receive tips on making your data usable.
 
Watch Video

Create the dual axis and synchronize it. Then, format the worksheet to remove all gridlines, zero lines, axis rulers, and borders. Now we have a standard donut chart!

Tableau Formatting Series: How to Use Lines and Borders

Donut Chart

 

Cutting the donut in half

To create a half donut without losing any measures, we need a second copy of the measure used for the donut angle. Copy the measure, and replace it on the Angle property with the Measure Values measure. In the Measure Names filter, select the original measure and the new copy. Set the Measure Names dimension as the first dimension on the Marks card. This should result in a pie where each arc appears twice, once on the right half and again on the left.

Measures

Next, set your axis to start at the Placeholder Axis value. Since my placeholder axis is set to zero, I adjust the axis range to (0,1). Now the left half of the chart is hidden. This sheet will be the top layer of your pie chart.

Semi Donut

 

Making the second layer

Duplicate the worksheet to create a base for the outer layer. First, increase the size of the white center until it exactly covers the entire donut, then increase it a bit more. Now, increase the size of the outer layer until it becomes visible again.

Resize the marks

Add the second dimension to the bottom of the Marks card. I’m using Region as my second dimension. Order is important here: the Measure Names dimension must appear first, followed by the dimension from the inner layer, and then the new dimension should be last. This arrangement ensures that each value appears on the left side of the circle and that values are grouped by the original dimension values.

Add Dimension

 

Assembling the Semi-Sunburst chart

Place the bottom layer onto the dashboard and position it as desired. Resize to fill the space if needed. Note the Layout coordinates and size.

Add Lower Layer

Bring the upper layer onto the dashboard and use the Layout menu to precisely position it on top of the lower layer. Now you have assembled the semi sunburst chart!

Make your data more usable with our free newsletter.

Get monthly tips and tutorials:

Depending on your use case, consider adding a Viz in Tooltip to display the values in the outer ring, along with a table or list to be displayed alongside the semi sunburst chart.

How to Show Top 10 Lists in Tableau Tooltips

Here’s a screenshot of the result.

Final Image

Visit Playfair’s Tableau Public page to interact with the viz and download a copy for yourself!

Thanks for reading,
Felicia


Access Exclusive Benefits

Dashboard templates, digital credentials, and more.

Related Content

Ryan Sleeper

Separate overlapping marks to reveal more underlying data Learn how to improve charts like box-and-whisker plots that have lots of…