Skip to content Skip to sidebar Skip to footer

Power Bi Show Percentage And Value On Bar Chart

Introduction

Power BI is a business analytics service that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. One of the most important features of Power BI is the ability to create charts with different types of data. Bar charts are a great way to display data, and in this article, we will show you how to show percentage and value on a bar chart in Power BI.

Bar Chart In Power Bi

Create a Bar Chart in Power BI

The first step is to create a bar chart in Power BI. You can do this by going to the "Visualizations" pane and selecting "Bar Chart." Then, you can drag and drop the data fields you want to use for the chart into the "Values" and "Axis" sections. Once you have done this, you should see a basic bar chart on your screen.

Visualizations Pane In Power Bi

Show Value on Bar Chart

The next step is to show the value on the bar chart. This is important because it will help people understand the exact value of each bar. To do this, you need to go to the "Format" pane and select "Data Labels." Then, you can toggle the "Value" switch to "On." This will show the value on each bar in the chart.

Format Pane In Power Bi

Show Percentage on Bar Chart

If you want to show the percentage on the bar chart, you need to follow a similar process. First, go to the "Format" pane and select "Data Labels." Then, toggle the "Percentage" switch to "On." This will show the percentage on each bar in the chart.

Percentage In Power Bi

Show Both Value and Percentage on Bar Chart

If you want to show both the value and percentage on the bar chart, you can do this by following the same steps as above. First, go to the "Format" pane and select "Data Labels." Then, toggle both the "Value" and "Percentage" switches to "On." This will show both the value and percentage on each bar in the chart.

Conclusion

In conclusion, showing percentage and value on a bar chart in Power BI is a great way to make your data more understandable and accessible to others. By following the steps outlined in this article, you can create a bar chart with both percentage and value, and share your insights with others in a clear and concise way.

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