Power BI: Show Both Value and Percentage in Bar Chart


Often you may want to create a bar chart in Power BI and display both the value and the percentage.

The easiest way to do this is by using the Table visual and by using Data bars as conditional formatting.

The following example shows how to create the following bar chart in Power BI that shows both the value of the bars and the percentage of the total that each bar represents:

Power BI bar chart show value and percentage

Let’s jump in!

Example: How to Show Both Value and Percentage in Bar Chart in Power BI

Suppose we have the following dataset in Power BI that contains information about total sales made at various stores:

Suppose that we would like to create a bar chart to visualize both the values in the Sales column along with the percentage of total sales that each store represents.

To do so, click the Report View icon on the left hand side:

Then click the Table icon under the Visualizations tab.

Then drag Store to the Columns panel and drag Sales to the Columns panel twice:

Next, right click on the first Sum of Sales and then hover over Conditional formatting, then click Data bars:

Next, right click on the second Sum of Sales and then hover over Show value as, then click Percent of grand total:

At this point, the bar chart will look like this:

The last step is to increase the width of the Sum of Sales column to make the bars easier to read and interpret.

To do so, click the Format your visual tab under Visualizations, then click the dropdown arrow next to Column headers, then click the dropdown arrow next to Options, then turn of Auto-size width:

Next, hover over the right hand side of the Sum of Sales header in the table until an arrow icon appears, then drag the width of the column to the right.

This will increase the width of the bars in the table:

Power BI bar chart show value and percentage

We have now successfully created a bar chart that displays both the value and percentages of each bar.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Apply Conditional Formatting to Bar Chart
Power BI: How to Add Average Line to Chart
Power BI: How to Create a Cumulative Line Chart

Leave a Reply

Your email address will not be published. Required fields are marked *