Question
How to show the total sum value on the top of the stack bar
Last Modified Date: 12 Apr 2022
Environment
- Tableau Desktop 2021.2.7
- Windows 10
- Cloudera Hadoop Hive
Answer
Workaround 1
Use reference line - If the negative exist, the total sum reference line will be placed in the middle of stack bar.
Workaround 2
Use dual axis - Create the second axis and make the marks as text. The total value will be shown, however the total value number is still in the middle of the stack bar if the negative value exist.
Workaround 3
Creating calculation field and add the calculation field in the label, move the label on the top of the stack bar. The label is only related to some of the category, if the relative category is removed or filtered, the value may be wrong.
Workaround 4
Create annotation instead of dynamic values.Attachment is a sample workbook includes 4 workarounds.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials