How to create a progress bar donut chart in Tableau

A progress bar donut chart is perfect for visualizing your data against a target and measure its progress.

Let us then see how to build step-by-step progress bar donut chart on Tableau. Our goal is to create a graph showing profit ratio per region from Sample Superstore data.

Step 1. Create the progress bar

1. Connect to the data source Sample – Superstore.
2. Create a calculated field. Let’s call it Other and type avg(1)-[Profit ratio].
3. Drag Profit ratio on Rows.
4. Drag Other on the y axis until two green rectangles appear.
5. Select Pie from the dropdown menu in the Marks card.
6. Drag Measure Values from Rows to Angle in the Marks card.
7. Drag Measure Names from Columns to Color in the Marks card. Edit the colours and fit to Entire view.

8. In the Measure Values box under the Marks card, invert the order of the two tabs. As to have Profit ratio first.
9. Drag Region to Columns.
10. In the Rows space, type avg(0) twice.

11. Right click on the second tab in Rows and select Dual axis.
12. Right click on the y axis on the right and select Synchronize axis.
13. Right click on the y axis on the left and select Show header.
14. Click on the second AGG(avg0) Marks card and drag away the two tabs. You will be left with four grey circles.
15. On the same Marks card, select the color white. Now you’ll have four white circles.
16. Click on the first AGG(avg0) Marks card and increase the size.
17. Clik back on the second AGG(avg0) Marks card and increase the size.

18. Drag Region on Profit ratio on Label in the second Marks card. Right click on the Profit ratio tab in that Marks card and select Format > Pane > Default > Numbers > Percentage > 0 decimal places.
19. Click on Label in that Marks card and align to the center.

20. Right click on the x-axis and select Show header.
21. Click on Format above the toolbar > Lines and select Zero Lines > None under the Sheet tab, and Grid Lines > None under the Rows tab. Done!

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