Forum Discussion
Stacked Barchart
Hi,
I have the following stacked bar chart. I would like that the total value show as a whole number instead of percentage. Is this possible? I cannot see any option to customize the total value.
Hello EsterBR
you can achieve what you want by using the following :
step 1 : use the stacked bar chart
step 2 : in x -axis use the measure that calculates the whole number value
step 4 : turn on the total
step 5 : under data labels, under values , use custom label and put the % measure .
let me know if this work out for you
in the measure, use format function to format your data so it shows as %
4 Replies
Hello EsterBR
you can achieve what you want by using the following :
step 1 : use the stacked bar chart
step 2 : in x -axis use the measure that calculates the whole number value
step 4 : turn on the total
step 5 : under data labels, under values , use custom label and put the % measure .
let me know if this work out for you
Daniel29195, it worked. How did you put the format as a %? I created the % measure and added it to the bar chart but it appears with this format.
The default format of the measure is %
in the measure, use format function to format your data so it shows as %
Thanks Daniel29195 !
