Forum Discussion
Stacked Column Chart Data Labels
I have a stacked column chart that has calculated measure (measure = sum of column A/sum of column B)
On first chart, column total label shows sum of stacked categories. I want to be able to show stacked chart as well as overall value(chart 2). Outside of doing a workaround line and stacked combo chart, is this possible?
Thanks!
Hi JinDR - This isn't currently possible with the native Stacked Column Chart.
The Total label always displays the sum of the stacked segments and cannot be bound to a separate measure (such as SUM(A)/SUM(B)).
If you need the overall calculation shown above the stack, the recommended workaround is to use a Line & Stacked Column Chart with your overall measure on the line series (hiding the line if desired so only the label is visible), or use a custom visual such as Deneb for complete control over the labels.
Hope this helps.
4 Replies
Hi JinDR - This isn't currently possible with the native Stacked Column Chart.
The Total label always displays the sum of the stacked segments and cannot be bound to a separate measure (such as SUM(A)/SUM(B)).
If you need the overall calculation shown above the stack, the recommended workaround is to use a Line & Stacked Column Chart with your overall measure on the line series (hiding the line if desired so only the label is visible), or use a custom visual such as Deneb for complete control over the labels.
Hope this helps.
Hi JinDR
i think you can go with Custometooltip option
Attched pbix file. pls check and let me know if it work for you
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Workaround: Line and stacked column combo: put your ratio measure on the line, hide the line, keep its data label.
or
Deneb: full control to stack the bars and place the ratio as a separate label on top.
If you don't need to customize your data label, you can enable Total labels. Outside this, you will need to use the line and column chart combo as others have already mentioned
