how to show 'total' labels on top of bar chart and not the labels by legend (measure option)

• 

  Kristoffer Drejer

  June 24, 2021 09:36

  Hi Joke, 

  Give this a go:

  First create a new measure, purpose is to figure out which group is the top group when the columns are stacked. 

  count(d-1:0, 0, m1)

   

  Next I like to add it as a line on the right axis, (we can't hide it, as the next steps won't work)

  Set the color for this measure to transparent colors, and remove diagram explanations, labels etc. 

  

  Next you create a conditional label on the measure you actually want to show the value for

  The condition is, that if the measure we created before = 1 then we want to show the row total. 

  

  

  In my case it seems that the label isn't shown on all months. It seems to be related to the top dimension in that month being very small, and therefor Targit seems to hide the label. You might be lucky that it isn't an issue for you. Otherwise, you might need to play around with an extra measure of some sort, where you inflate the top dimension, if it is really small. 

  0
• 

  Ole Dyring

  June 24, 2021 09:40

  Hi Joke,

  You can do this by adding a calculation to your object, and then showing labels for this calculation as an invisible line in the stacked bar chart.

  In my example, I have added a Total calculation, sum(all, 0, m1) to my data:

  

  In a stacked bar chart, this would now look like a chart with four series of data. I have made sure to add a label to the Total calculation only:

  

  From the Chart tab, you can select the Total series and turn its Visualization into a Line - however, a Line with no line and no marker.

  

  Best regards / Ole

  1
• 

  Joke Laukens

  July 08, 2021 06:51

  thanks a lot for the help! this worked perfectly

  1

Please sign in to leave a comment.