Tableau Show Percentage Of Total In Bar Chart
Introduction
Bar charts are an effective way to visualize data in Tableau. They allow you to quickly compare values across different categories. However, sometimes it's not enough to just see the actual values. You may also want to see the percentage of each value out of the total. This can be done in Tableau by adding a percentage of total calculation to your bar chart. In this article, we will show you how to do this step by step.
Step 1: Create a Bar Chart
The first step is to create a bar chart in Tableau. To do this, drag the field you want to use as your category onto the columns shelf and drag the field you want to use as your measure onto the rows shelf. This will create a basic bar chart.
Step 2: Add Percentage of Total Calculation
To add a percentage of total calculation, right-click on the measure field on the rows shelf and select "Add Table Calculation". In the table calculation dialog box, select "Percent of Total" from the calculation type drop-down menu. You can also choose whether you want to calculate the percentage of total for the entire table or for each category.
Step 3: Format the Bar Chart
Once you have added the percentage of total calculation, you may want to format the bar chart to make it more visually appealing. You can do this by right-clicking on the chart and selecting "Format". From here, you can change the colors, fonts, and other visual elements of the chart to your liking.
Step 4: Analyze the Data
Now that you have created a bar chart with the percentage of total calculation, you can begin to analyze your data. You can quickly see which categories have the highest and lowest percentages of the total. This can help you identify trends, patterns, and outliers in your data.
Conclusion
Adding a percentage of total calculation to a bar chart in Tableau is a simple and effective way to visualize your data. It allows you to quickly see the relative size of each category and identify trends and patterns in your data. By following the steps outlined in this article, you can easily create a bar chart with a percentage of total calculation in Tableau.