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
- Connect to the data source Sample – Superstore.
- Create a calculated field. Let’s call it Other and type avg(1)-[Profit ratio].
- Drag Profit ratio on Rows.
- Drag Other on the y axis until two green rectangles appear.
- Select Pie from the dropdown menu in the Marks card.
- Drag Measure Values from Rows to Angle in the Marks card.
- Drag Measure Names from Columns to Color in the Marks card. Edit the colours and fit to Entire view.
- In the Measure Values box under the Marks card, invert the order of the two tabs. As to have Profit ratio first.
- Drag Region to Columns.
- In the Rows space, type avg(0) twice.
- Right click on the second tab in Rows and select Dual axis.
- Right click on the y axis on the right and select Synchronize axis.
- Right click on the y axis on the left and select Show header.
- Click on the second AGG(avg0) Marks card and drag away the two tabs. You will be left with four grey circles.
- On the same Marks card, select the color white. Now you’ll have four white circles.
- Click on the first AGG(avg0) Marks card and increase the size.
- Clik back on the second AGG(avg0) Marks card and increase the size.
- 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.
- Click on Label in that Marks card and align to the center.
- Right click on the x-axis and select Show header.
- 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.
