topic Re: 100% Stacked bar but show count values as data labels in App Development

100% Stacked bar but show count values as data labels

ckyrosis — Thu, 28 Aug 2025 09:57:37 GMT

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.

Re: 100% Stacked bar but show count values as data labels

lennart_mo — Thu, 28 Aug 2025 12:31:45 GMT

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

Re: 100% Stacked bar but show count values as data labels

ckyrosis — Thu, 28 Aug 2025 13:20:00 GMT

Worked perfectly, thank you!