How to only show the cumulative total label in stacked bars and not for each color in the bar

Question:
In bar charts, when the display label measure value is enabled, we’re getting individual values for different colors on a bar (displayed on the bar) as well as the cumulative value for the whole bar (displayed above the bar) by default. Is there provision to only display the cumulative value?

Solution:
There’s no out of the box setting to only show the cumulative value. Instead what we can do is create a custom expression of the form:

      max(' ')

and place it in the “Labels” shelf as shown below. This will essentially force empty character to be displayed for the individual stack elements of the bar.

1 Like