Power BI Bar Chart Show Value and Percentage

Do you want to show the value and Percentage in the Power BI bar chart? In this Power BI tutorial, we will see how to show value and percentage in the Power BI bar chart.

Also, we will cover the topics like:

  • Power BI shows values on the bar chart
  • How to show percentages in a bar chart in Power BI
  • Power BI bar chart shows the value and percentage

Power BI shows values on the bar chart

Here, we will see how to show values on the Power BI bar chart.

For example, we will use the Financial sample data to create a Power BI bar chart.

power bi bar chart show values

Using this data, we will create a stacked bar chart that displays sales based on segment. However, the chart will not show any data labels or values in the Power BI bar chart.

how to show values in power bi bar chart

We need to enable the Data label option from the Format pane to show the values in the Power BI bar chart.

Follow the steps below to display the value in the Power BI bar chart by enabling the Data label.

  • Open Power BI Desktop and Load the data by using the Get data option.
  • To create a Stacked bar chart, select the chart from the visualization pane.
  • Drag and drop the Segment and sales to the Y-axis and X-axis, respectively.
power bi show values on bar chart
  • To show the value in the Power BI bar chart, click on the format icon in the Visualization pane.
  • Then enable the Data label option, and you can format the data label by changing the font color, size, etc, based on the requirement.
  • Now, you can see the values in the Power BI bar chart.
Microsoft power bi show values on bar chart

This is how to show the values in the Power BI bar chart.

See also  Power BI Measure multiply with examples

How to show percentages in a bar chart in Power BI

Here, we will see how to show the percentage in the Power BI bar chart.

For example, we will use the same sample Excel data and utilize columns such as Sales and Segment to display sales based on segment. We have enabled the data label, as shown below.

how to show values in microsoft power bi bar chart

To show the percentage in the Power BI bar chart. Follow the below steps:

  • In Power BI Desktop, select the bar chart from the visualization pane.
  • Then, drag and drop the Sales and segments to the X-axis and Y-axis.
how to show percentage in bar chart
  • To show the percentage, in the Power BI bar chart, for this, click on the dropdown next to ‘Sum of Sales’.
  • Next, click on the ‘Show value as‘ option.
how to show percentage in Power BI  bar chart
  • Then select the Percent of Grand total option.
show percentage in Power BI  bar chart
  • You can see the percentage displayed in the Power BI bar chart.
how to show percentage in bar chart in power bi

This is how to show the percentage in the Power BI bar chart.

Power BI bar chart shows the value and percentage

Here, we will see how to show the value and percentage in the Power BI bar chart.

For example, we will use the same financial data to create a bar chart that shows sales based on segment.

Then, we enable the data label in the format pane to display the value in the Power BI bar chart, as shown below.

power bi bar chart show value and percentage

Unfortunately, Power BI bar charts can only display either the value or the percentage, not both simultaneously. However, we have a trick to address this limitation, i.e., by utilizing the “Details” feature of the Data label.

See also  Power Automate Switch Case [How to Use]

Follow the steps below to show the value and Percentage in the Power BI bar chart.

  • First, we will create a measure that will calculate the sales percentage.
  • So, click on the New measure, in the Formula box, write the below measure.
Percent = DIVIDE(SUM(financials[ Sales]),CALCULATE(SUM(financials[ Sales]),ALL(financials)))
  • Then select the Percentage as Format.
Microsoft power bi bar chart show value and percentage
  • Next, select the Stacked bar chart from the visualization pane.
  • Drag and drop the Sales and Segment to the X and Y axis fields, respectively.
How to show value and percentage Microsoft power bi bar chart
  • To show the value and percentage in the Power BI bar chart, do the following:
  • Select the visual, and click on the format pane.
  • Scroll down to the Data label section and enable it.
  • Expand the Data label section, then enable Details.
How to show value and percentage power bi bar chart
  • Then, expand the details under Data, and click on the +Add data button.
  • Then select the Percent measure from the table.
  • Then select the Display units as None.
How to show value and percentage power bi stacked bar chart
  • Now, you can see the Power BI bar chart shows value and percentage.
show value and percentage in power bi stacked bar chart

This is how to show the value and percentage in the Power BI bar chart.

Conclusion

In this Power BI tutorial, we saw how to show value and percentage in the Power BI bar chart.

Also, we saw how to show

  • Values on the Power BI bar char
  • Percentage in the Power BI bar chart.

You may also like:

>