Stacked column with percentage instead of value, but while keeping value scale

[Anonymous]

Hello all, 

This is my first post here, and I am new to Power BI, but I have not seen (or been able to find) someone approaching this topic yet.

I am looking to show a volume forcast by year split by product sales. I am looking to use the unit sales of the as the scale, but display the percentage the product sales instead of the unit. I would like to display still the total number of units sold at the top.

This makes a very visual way to show the growth over time of overall sales, while giving a comprehensive percentage to show the products performance in the portfolio. 

Sorry if it is not a 100% clear, but I can show an example created in excel below. Note the total is in thousands.

[CR]

Hi @Anonymous

I'm not sure I understand well what you need but here are 2 things to check that Values are displayed with no calculation:

if it is not the case, please make aprint screen with your visuals or share a simple PBIX directly (really easier to solve it).

Regards,

CR