Power BI - Showing Data Labels as a Percent

In this Power BI tutorial, I show you how to set up your data labels on a bar or line chart to show % instead of the actual value in the Y-axis. This is an awesome trick that allows you to show multiple ideas on the same chart.

Blog Post:

Link to PBIX:

Enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[lisajonescastronova]

Thank you! I literally spent 2 hours trying to figure this out on my own. Finally I found your video. [feeling saved!!!]

[AISHWAR]

Smartly done. Using the transparent colour measure was really clever.

[rustice]

Just love the simplicity of this, thanks for sharing

[havenscr]

Nicely done parker! I've used this technique for showing the grand total on a stacked column chart, but have never thought of utilizing it for percentages. Well done!

[ArmandoBash]

I WAS LOOKING FOR THIS EVERYWHERE AND YOU ARE THE ONLY ONE WITH THE ANSWER! THANK YOU!!! Just liked and subscribed for giving this gold tip.

[bikerchick]

This is a super slick way to do this. I'm glad I stumbled on it. Thanks.

[MichaelDoig]

Great stuff mate, re: Line chart % of total. How do you do it with a legend involved though? Say revenue was broken into 3 categories, I wanted to show the % of grand total for a given date (or quarter) for each group/legend?

[myazigi]

I don't know what are you up to, Parker, but you did it....again!! Thank you so much for your awesome tips.

[franklineojong]

Hello, thanks very much for video, but the percentage icon in Power Bi is not activated. How can i adjust percentages of charts

[DaxtasticNL]

Very nice job Parker! I love your video's with all the neat tricks! Keep up the good work!

[junaidmalik]

This is something i was struggling with a while ago. I got the solution now . THANK YOU😊

[kanwalsingh]

Thank you, will try on Planned vs actual data in %.

[DIGITAL_COOKING]

Absolutely great video 👍, i see YouTube becoming the greatest place to learn for free

[ycchin]

Is it possible to have correct YoY % value if I select filter 2 years bar charts?

[maps]

Thanks for this great tip.

I'm however at an impasse in trying to get the same result in a Line and Stacked Column Chart with sub categories.
In your example, if you add a sub-category (column series) to the chart, which would split the column Personal Accessories (as well as other columns, where available) in several stacked columns, how could one then get a percentage value as data label for each sub-category, while still keeping the Y axis as values (Revenue in your example) instead of percentage?

[supremelvel]

dude you are a life saver. thank you so much!

[DreeKun]

Very neat trick! I wonder how you discover all of this tricks... :)

[shivamkapoor]

I have a data set, which has a calculated column with values expressed in %. How do I depict the data labels of that column whilst plotting a line chart or bar chart?

[Dravidan]

I want to show both, the values and percentage! Any solution?

[harrietp]

Really helpful, thanks. Please can you also explain how to display raw values as percentages? I need to visualise survey responses by showing % of respondents agreeing or disagreeing with statements. I don't have the total number of respondents, only the % of replies in each category. I want my data labels to show % sign, eg 54%, 32%, etc.