Calculate Bar Chart Percent of Total in Power BI

Watch this basic bar chart introduction in Power BI to understand how to calculate the percent of total on your visualization. We'll use a simple DAX calculation to get the job done.

★☆★ Join this channel to get access to perks: ★☆★

★☆★ SUBSCRIBE TO ME ON YOUTUBE: ★☆★

★☆★ FOLLOW ME BELOW: ★☆★

If you find my material useful, care to buy me a coffee?

[bahman]

cool, finally i found someone work with powerbi and tableau :)
my questions are coming :)

[DragonWhisky]

Thank you very much for your video, it helps me a lot.

[vivekmodi]

Hi Antony thanks for the excellent explanation. What should I do if I need percentage representation and the top N filter on the qualitative data? Like how many times one city is mentioned in the list by percentage?

[sumyatnoemyintmg]

Thanks a million. It was effective for me.

[AlclrpTspekwndqhrdlsp]

Is there any way I can display both the value and percentage on the bar chart? I can do this on a pie chart, but no option for this on a bar chart.

[zakkyang]

Thank you. But how do you stack them all in the same bar and categorized them by different brands?

[agradoville]

I'm a newbie to BI. Would it be possible for you to upload the data set so that I can see what the formatting of the data looks like prior to bringing it into BI? thanks

[olgagilhooley]

Great video. What version of Power BI is this? When I use the bar chart visualization I do not have the "Color Saturation" field.

[damyankolarov]

Thanks! How do I get the share of each brand per year in a stacked bar chart?

[mufycw]

Hi @AnthonySmoak, I need your help on this, was wondering if you could guide me. In my data i dont have a sales amount field I have data of appointment id which i use to count my total appointments by months. And I have diseases name as a category field. so what I did is i created a new column and inserted 1 in each row to make it a value field. I used the same formula and in place of sales column I used my value field column and in place of category field I used my disease field but I am getting error "Too many arguments were passed in sum function. The maximum count for the function is 1". Earlier I was using direct appointment id in place of sales field but that was also not working because it is text field so i created a value field with value 1 in each row.

[abdulqadeerkamangar]

How can we create scattered column chart by only selecting Top 5 x and y axis?

[Nundalose]

Great video, very informative. Is there a way to keep the sales value still up while also including the percentage?

[SatvikKapoor]

Sir how to make the x-axis as 0% 10% 20%..until 100%..

[rodeolove]

my bar charts are all smushed together... how do I add spacing? or is it my data set

[mjflores]

Whats the formula of percentage? Could hardly see and hear the video. Thank you!

[kennethstephani]

Video was great but sound was not ... very low volume, the end of most of your sentences is inaudible.