My customer wants to see the totals of each bar on top of the bar, instead of seeing each individual figure by legend part. I can't find an option to do this. Thanks in advance for your help!
Kristoffer Drejer 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.
Ole Dyring 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
Joke Laukens thanks a lot for the help! this worked perfectly 
Comments
3 comments