Skip to content Skip to sidebar Skip to footer
Home / Chart

Power Bi Stacked Bar Chart Show Percentage And Value

Power Bi Stacked Bar Chart

Introduction

Power BI is a data visualization tool that allows businesses to analyze data and gain insights into various aspects of their operations. One of the most popular types of visualizations in Power BI is the stacked bar chart. This chart type is ideal for showing the relationship between different categories and their values. In this article, we will explore how to create a stacked bar chart in Power BI that shows both the percentage and value of each category.

What is a Stacked Bar Chart?

A stacked bar chart is a type of chart that displays data using bars. Each bar represents a category, and the height of the bar represents the value of that category. The bars are stacked on top of each other, with the height of each section of the bar corresponding to the value of a sub-category. This allows for the comparison of the different sub-categories within each category.

Creating a Stacked Bar Chart in Power BI

To create a stacked bar chart in Power BI, follow these steps:

  1. Open Power BI and select the data you want to visualize.
  2. Select the "Stacked Bar Chart" option from the "Visualizations" pane.
  3. Drag and drop the category field into the "Axis" field well.
  4. Drag and drop the value field into the "Values" field well.
  5. Drag and drop the sub-category field into the "Legend" field well.
  6. Click on the "Format" tab to customize the appearance of your chart.

Show Percentage and Value in Power BI Stacked Bar Chart

By default, a stacked bar chart in Power BI only shows the value of each category. However, it is possible to add the percentage of each sub-category as well. To do this, follow these steps:

  1. Select the stacked bar chart you want to modify.
  2. Click on the "Data" tab.
  3. Click on the "Value" field.
  4. Select "Show Value As" and then "Percent of Column Total".

Once you have completed these steps, the stacked bar chart will display both the value and percentage of each sub-category.

Customizing Your Stacked Bar Chart

Power BI allows you to customize your stacked bar chart in many ways. Here are a few examples:

  • Change the colors of each sub-category.
  • Adjust the width of the bars.
  • Add data labels to each section of the bar.
  • Remove the legend or move it to a different location.

Conclusion

A stacked bar chart is an excellent way to visualize relationships between categories and their values. By adding the percentage of each sub-category, you can gain even more insights into your data. Power BI makes it easy to create and customize these charts, allowing you to present your data in a clear and visually appealing way.

Related video of Power Bi Stacked Bar Chart Show Percentage And Value

You may like these posts :