Pie Chart With Multiple Measures in Tableau : Abhijeet
by: Abhijeet
blow post content copied from SalesForce FAQs
click here to view original post
### Summary of the Content The content discusses how to create a pie chart in Tableau that displays multiple measures, specifically Sales, Profit, and Quantity, in a single view. Initially, a standard pie chart was created to analyze sales data by region. The tutorial guides users through the steps to create a more complex pie chart that combines these measures, allowing for better data comparison. **Key Steps to Create a Multi-Measure Pie Chart:** 1. **Connect to Data:** Use the Tableau Superstore dataset. 2. **Filter Measures:** Add Measure Names to the Filters and select Sales, Profit, and Quantity. 3. **Configure the Chart:** - Drag Measure Names to the Color card. - Add Measure Values to the Text card. - Change the chart type to Pie Chart. 4. **Display Values:** Drag Measure Values to the Slices card to show data distribution. 5. **Format Values:** Adjust the display settings to show values in thousands (K). 6. **Add Dimensions:** Include a dimension (like Region) to compare measures across different categories. 7. **Show Percentages:** Create formula fields to display Sales and Profit as percentages. The tutorial concludes by emphasizing the benefits of using a pie chart for multiple measures and suggests alternative chart types like Sunburst or trellis charts for better analysis. ### Additional Context Creating pie charts with multiple measures in Tableau can enhance data visualization, making it easier to interpret complex datasets. However, it’s important to note that while pie charts can be visually appealing, they may not always be the best choice for detailed data analysis, especially when comparing numerous categories or measures. ### Hashtags for SEO #Tableau #DataVisualization #PieChart #MultipleMeasures #SalesAnalysis #TableauTutorial #DataAnalytics #BusinessIntelligence #TableauTips #DataScience
Recently, I created a Pie chart for the sales data analysis of products in our company. In this pie chart, I displayed the sales distribution across the various regions. Later, I got a requirement to create a pie chart that combines the measures Sales, Quantity, and Profit in a single view.
To show the data of Sales and Profit measures, I created a Pie chart using multiple measures. Unlike a standard pie chart, this pie chart allows us to compare more than one measure at a time in the same chart.
In this Tableau tutorial, I will explain how to create a Pie chart with multiple measures in Tableau.
Create a Pie Chart With Multiple Measures in Tableau
To create a Pie chart with multiple measures, we will use the Tableau Superstore dataset. Now, connect the Tableau with the data source and follow the steps below.
In this Pie chart, we will use all the measures collectively to analyze the multiple measures. But here we need only the measures of Sales, Profit, and Quantity.
To filter out the measures, first add the Measure Names to the Filters section.
In the filters, select the checkboxes for the measures you need to include in the pie chart. After selecting the measures, click OK
Now, drag the filtered Measure Names to the Color card in the Marks section.
After this, add the Measure Values to the Text card in the Marks. The Measure Values will reflect the values of selected measure names.
Now, select the chart type from Automatic to Pie Chart. This will show the selected measures in the Pie chart.
Currently, the pie chart slices do not display data distribution based on the measure values.
To display the exact values or share, drag the Measure Values to the Slices card. With this, we can see the distribution of color in the pie chart according to the measure values.
To display the measure names along with the measure values, drag the Measure Names from Filters to the Text card in the Marks section.
With this, we can see the measures profit, quantity, and sales with their measure values in a single pie chart.
Here, we can also format the measure values, like removing the decimal and showing the suffix K for thousand. For this, click on the Measure values in the Marks section and select Format.
In the format, go to the Default section and select Numbers -> Number(Custom), then select Decimal places as zero and Display Units as Thousands(k).
Now, we can see in the pie chart that the measure values are displayed without decimals with a “K” suffix for thousand.
Add Dimension for Multiple Measures in a Pie Chart
In this multi-measure pie chart, we can also add a dimension to compare the measures with respect to the dimension. For example, we can add Region (dimension) to compare the measures sales, profit, and quantity across regions.
To add a dimension, add the Region to the Details card in the Marks section.
Change the region from Details to Color in the Marks section.
Now, we can see the pie chart color in a gradient of colors, with dimensions and measure values.
This way, we can add dimension to the multi-measure Tableau pie chart.
While using this method, you can add a dimension like Region inside the same pie along with multiple measures. But in this method, the chart becomes hard to analyse data for multiple measures.
If you want to show both measures and dimensions together, it’s better to use the Tableau Sunburst chart or create a trellis chart for pie charts.
Show Percentage for Multiple Measures in a Pie Chart
In the above pie chart, we displayed multiple measure values in Numbers. In a Pie chart, we can also display the values of Multiple measures in percentages.
Let’s say we want to display the Sales and Profit percentage in the above pie chart. For this, we need to create a formula field as shown below.
//Sales Percentage
SUM([Sales]) / (SUM([Sales]) + SUM([Profit]))
//Profit Percentage
SUM([Profit]) / (SUM([Sales]) + SUM([Profit]))Now, replace the calculated fields Profit% and Sales% with the Measure Values profit and sales.
In the Marks section, click on the Measure Values and select Format.
In the Format, go to the Default section and in the Numbers field, select Percentage.
Now, we can see the measure values labeled on the pie chart in the percentage format.
This way, we can display the percentage of values in the multiple-measure Tableau Pie chart.
Conclusion
In this tableau tutorial, we learned how to create a Pie chart with multiple measures in Tableau. We created a standard pie chart and then combined measures like Sales, Profit, and Quantity into a single pie chart.
We also learned how to add a dimension in a Pie chart with multiple measures. At last, we created formula fields to display the data in percentages instead of numerical values in the multi-measure Tableau pie chart.
You may also like to read:
The post Pie Chart With Multiple Measures in Tableau appeared first on SalesForce FAQs.
August 20, 2025 at 10:33PM
Click here for more details...
=============================
The original post is available in SalesForce FAQs by Abhijeet
this post has been published as it is through automation. Automation script brings all the top bloggers post under a single umbrella.
The purpose of this blog, Follow the top Salesforce bloggers and collect all blogs in a single place through automation.
============================
Post a Comment