Showing Percentages in Stacked Column chart (instead of absolute values)

[Anonymous]

Hello All,

I'm trying to implement a Stacked Column chart where instead of showing absolute numbers, I wanted the break-up by percentages. 

Please note, I don't want a 100% Stacked column chart as I don't want all X-axis values to amount to 100% rather it should be their absolute values which determine the length of the data bars. 

Please refer the dummy data set and the graph I'm trying to depict. For now, I have achieved this by showing in Tooltips (using ALLEXCEPT) but the users tend to take printouts than use the dashboards ☹️ . This implies I need to present percentages in the graph and not in tooltips. 

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. 

Note: I have posted this in DAX group a month back, and I haven't got a clear answer. I'm keen to know, if this can be done in Power BI.

Thanks, 

Varun

[parry2k]

@Anonymous is this what you want? What you mean by %

[Anonymous]

@parry2k 

Many thanks for your response. 

I'm more looking something like this: 

The bar length would be based on the absolute country sales, whereas the percentages would amount to 100% for each country. 

Thanks, 

Varun

[parry2k · Accepted solution]

@Anonymous I don;t think it is not possible, basically you want Y - Axis values to be absolute number but show % as data label, and currently it is not possible to show custom data labels. Having said that, add this as an ideas forum or vote for an existing idea if exists.

[Anonymous]

@parry2k 

Many thanks. Will check and update this in the Idea forum.

Thanks for the help.

Regards,

Varun

[Gladiator909]

@parry2k Any updates on that? We are still stuck trying to make this work and clearly cannot be done. Another feature needs to be added... this can easily be done on Excel but not powerbi