100% Stacked bar but show count values as data labels

[ckyrosis]

I have a stacked bar with years as dimension and the split of genders as measures. 

I want it to be a 100% stacked bar like this so that the bars are of equal lengths across all years, but I want the data labels to be the count value instead of the % value. 

These are the current options that I have on the presentation menu. 

[lennart_mo · Accepted solution]

Hi @ckyrosis,

to achieve this you need to use the DUAL() function in your expression and set the Number formatting to 'Measure expression'. 

So your Measure would look like this:

=Dual(CountExpression, PercentageExpression)

That way it returns one text value, the first expression, and a numerical value, the second expression.

Just keep the segment labels enabled and you should get your desired result.

Best regards

Lennart

[ckyrosis]

Worked perfectly, thank you!