Forum Discussion

EsterBR's avatar
EsterBR
Helper II
2 years ago
Solved

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....
  • Daniel29195's avatar
    2 years ago

    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's avatar
    Daniel29195
    2 years ago

    in the measure, use format function to format your data so it shows as %