Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Worked perfectly, thank you!