Tableau Pie chart using Multiple Measures

This article shows how to create a Tableau Pie chart using multiple measures with an example. Generally, we use a pie chart to display region-wise sales, category sales, etc. However, we can create a pie chart where each slice represents a measure (sales, actual cost, dealer price, etc.).

To create a Tableau Pie chart using Multiple Measures, drag and drop Measure Names to the Columns shelf and Measure Values to the Rows shelf. The desktop will automatically create a bar chart with all the available Measures.

If you observe the below screenshot, you can see all the numeric fields with the # symbol are available in the report section.

Auto Generated Bar Chart from Row and Column Shelf

As there is no balance between the data, let me remove the Yearly Income, Count of Custom SQL Query, and order Quantity by simply dragging them Measure Values. Otherwise, select them and click the Exclude button to filter them.

Remove unwanted Measures

Tableau Pie chart using Multiple Measures

Next, drag the Measure Names field from the Columns shelf to the Color Shelf.

Add Measure Names to Color for creating Tableau Pie chart using Multiple Measures

Next, drag Measure Values from the Rows shelf to the Size Shelf. It automatically converts the chart to a Treemap.

Treemap

Please change the Marks from Automatic to Pie.

Change Marks type from Automatic for Tableau Pie chart using Multiple Measures

You can see the Tableau Pie chart using Multiple Measures, so let me add the data labels.

Tableau Pie chart using Multiple Measures output

Use the control button to select the Measure Names and Measure Values in the Color and Size shelf and drag them to the Label shelf. The below screenshot shows the data labels.

Add Data labels to Tableau Pie chart using Multiple Measures

You can use the following links to format the Pie chart.

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.