Power Bi Stacked Bar Chart Percentage Of Column Total

Power BI is an excellent tool for data visualization and analysis. One of the most commonly used chart types in Power BI is the stacked bar chart. The stacked bar chart is an effective way to display data in a visually appealing way, especially when you want to show how different components contribute to the whole. In this article, we will discuss how to create a stacked bar chart in Power BI and how to display the percentage of column total in the chart.

What is a Stacked Bar Chart?

A stacked bar chart is a chart type that displays data in bars, with each bar representing a category. The bars are divided into segments, with each segment representing a subcategory. The height of each segment represents the value of the data for that subcategory. The stacked bar chart is an effective way to display data in a visually appealing way, especially when you want to show how different components contribute to the whole.

How to Create a Stacked Bar Chart in Power BI

Creating a stacked bar chart in Power BI is a simple process. Here are the steps:

Open Power BI and select the data you want to use for your chart.
Click on the "Visualizations" button in the right-hand pane.
Select "Stacked Bar Chart" from the list of chart types.
Drag and drop the fields you want to use for the chart into the "Values" and "Axis" boxes.
Customize your chart as desired, including changing the colors, adding axis titles, and adjusting the legend.

How to Display the Percentage of Column Total in a Stacked Bar Chart

Displaying the percentage of column total in a stacked bar chart in Power BI is a great way to provide additional context to your data. Here are the steps to display the percentage of column total:

Related Chart

Select the stacked bar chart you want to add the percentage of column total to.
Click on the "Visualizations" button in the right-hand pane.
Scroll down to the "Data Labels" section and toggle on the "Data Labels" switch.
Select the "Value (percentage of column total)" option from the dropdown list.

Conclusion

The stacked bar chart is an effective way to display data in a visually appealing way, especially when you want to show how different components contribute to the whole. Power BI makes it easy to create a stacked bar chart and display the percentage of column total in the chart. By following the steps outlined in this article, you can create a powerful visualization that provides valuable insights into your data.