Home » Power BI » Turn on Total labels for stacked visuals in Power BI

Turn on Total labels for stacked visuals in Power BI

Turn on Total Labels

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

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

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

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.

Leave a Reply