cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
varunbijur
Frequent Visitor

Percentages instead of Numbers in Stacked Column chart

Hello All,

 

One query on Line & Stacked column chart implementation.

I need to show Percentages instead of Numbers in Power BI- Stacked column chart

 

The data set example is provided below. 

 

CountrySalesBusiness/Customer
France2000B
France1000C
UK3000B
UK2000C
Germany4000B
Germany1000C
Spain2000B
Netherlands2000B
Netherlands500C
Italy1000B
Italy200C
Portugal1200B
Portugal300C

 

The visual I'm trying to generate is provided below. 

 

Perc.JPGThe only change required is instead of numbers it should show percentages. 

 

Ex. For Germany, in Business it should be 4000/5000 = 80%, whereas for Customer it should be 1000/5000 = 20%

 

Also the column length is based on the total sales for each country. 

Can you please help with what can be the possible tweak in Power BI which would help me get to this final state. 

 

Thanks 🙂

 

Regards,

Varun

3 REPLIES 3
PR20048119 Memorable Member
Memorable Member

Re: Percentages instead of Numbers in Stacked Column chart

Hi @varunbijur 

 

Use 100% stacked column chart.

 

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

varunbijur
Frequent Visitor

Re: Percentages instead of Numbers in Stacked Column chart

@PR20048119 

The idea is not to use 100% stacked column chart. As I want the 'Sales' for each country to determine the size of the columns (and not by 100% value).

lg77
Regular Visitor

Re: Percentages instead of Numbers in Stacked Column chart

Hi, I have not implemented this yet myself, but I came across this article a few weeks ago - I believe it's what you're looking to accomplish and seems fairly simple: https://bielite.com/blog/percent-data-labels/. Good luck!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors