Skip to content Skip to sidebar Skip to footer

Power Bi 100 Stacked Bar Chart Show Values

Power Bi 100 Stacked Bar Chart Show Values

Introduction

Power Bi is a powerful data visualization tool that can help you turn data into insights. One of the most useful features of Power Bi is the stacked bar chart, which can be used to show the distribution of data across different categories. However, sometimes you may want to display the actual values of each category in addition to the percentages. In this article, we will show you how to create a Power Bi 100 stacked bar chart that shows both the percentages and values.

Step 1: Create a Stacked Bar Chart

The first step is to create a basic stacked bar chart in Power Bi. To do this, follow these steps:

  1. Select the data you want to use for the chart.
  2. Click on "Visualizations" in the sidebar.
  3. Select "Stacked Bar Chart" from the list of available visualizations.
  4. Drag and drop the fields you want to use for the chart into the "Values" and "Axis" sections.
  5. You should now have a basic stacked bar chart.
Power Bi Stacked Bar Chart

Step 2: Add Data Labels

The next step is to add data labels to the chart. Data labels will display the actual values of each category in addition to the percentages. To add data labels, follow these steps:

  1. Select the chart.
  2. Click on the "Format" tab in the sidebar.
  3. Expand the "Data Labels" section.
  4. Toggle the "Value" option to "On".
  5. You should now see the actual values of each category in addition to the percentages.
Power Bi Stacked Bar Chart Data Labels

Step 3: Format the Data Labels

The final step is to format the data labels to make them easier to read. To format the data labels, follow these steps:

  1. Select the chart.
  2. Click on the "Format" tab in the sidebar.
  3. Expand the "Data Labels" section.
  4. Adjust the font size and color as desired.
  5. You can also choose to display the values in different formats, such as currency or percentage.
Power Bi Stacked Bar Chart Formatted Data Labels

Conclusion

By following these simple steps, you can create a Power Bi 100 stacked bar chart that shows both the percentages and values. This can be a useful visualization tool for showing the distribution of data across different categories, and can help you make informed decisions based on your data.

Related video of Power Bi 100 Stacked Bar Chart Show Values