topic Percentages instead of Numbers in Stacked Column chart in DAX Commands and Tips

Percentages instead of Numbers in Stacked Column chart

Anonymous — Mon, 20 Jan 2020 11:16:35 GMT

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.

Country	Sales	Business/Customer
France	2000	B
France	1000	C
UK	3000	B
UK	2000	C
Germany	4000	B
Germany	1000	C
Spain	2000	B
Netherlands	2000	B
Netherlands	500	C
Italy	1000	B
Italy	200	C
Portugal	1200	B
Portugal	300	C

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

The 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

Re: Percentages instead of Numbers in Stacked Column chart

Anonymous — Mon, 20 Jan 2020 13:06:33 GMT

Hi Anonymous

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.

Re: Percentages instead of Numbers in Stacked Column chart

Anonymous — Mon, 20 Jan 2020 13:14:10 GMT

Anonymous

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).

Re: Percentages instead of Numbers in Stacked Column chart

lg77 — Wed, 22 Jan 2020 03:00:28 GMT

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!