Now you can turn on total labels for stacked bar chart, stacked column chart, stacked area chart, and line and stacked column charts. This is Power BI September 2020 feature.
Prerequisite: Update Power BI latest version from Microsoft Power BI official site.
Sample Dataset format as below:
| Year | Sales | Profit |
| 2014 | 15000 | -6000 |
| 2015 | 10000 | -5000 |
| 2016 | 11000 | 12000 |
| 2017 | 9000 | -4000 |
| 2018 | 13000 | 13500 |
| 2019 | 11000 | 12000 |
| 2020 | 9000 | -4000 |
Let’s start with an example:-
Step-1: Display year wise sales & profit in stacked column chart visual.
Stacked Column Chart 1
Step-2: Select visual and go to format bar & Turn on Total labels option & set the basic properties like Color, Display units, Text size & Font-family etc.
Turn on Total Labels
Step-3: If you interested to see negative sales totals then you have to enable Split positive & negative option.
Split Negative & Positive values
Note:
- Same you can enable for stacked bar chart, stacked area chart, and line and stacked column charts.
- For single value Total labels option will not appear.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.