Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Power BI total labels not working when only one option in stacked bar chart

When total labels are turned on, the labels do not show when data is sliced to an option that has only one legend category. 

 

See here, the data is sliced and there are multiple legend values. The total labels work.

rbrocks_0-1655731453368.png

 

Here in the same chart, the data is sliced and there is only one legend value. The total labels disappear. 

rbrocks_1-1655731523124.png

We don't want to enable regular data labels, only the total. Is this intended functionality? Or is this a bug? Seems like if I choose total labels on they should always work by default.

 

Status: Needs Info
Comments
msaville
Frequent Visitor

Are Microsoft aware of this bug yet?

TurtleToes
New Member

OMG.  I just stumbled into a 'solution' for this.  You just also need to turn on the Data labels.  It is the option right above Total labels in the Format Visual>Visual menu.  Order of operations may matter, I had the Total labels set up and working first.  Realized the Totals disappeared when testing my filters.  Then I turned Data labels on expecting to do some sort of conditional logic as a work around.  Very surprised it just worked.

Mouse
Frequent Visitor

Microsoft, please, this is ridiculous. Please fix this!!

msaville
Frequent Visitor

Agreed with @TurtleToes , I've managed to stumble across this as well this morning.

 

Turning on data labels with the same format as the total labels will allow it to work how we want, granted data labels aren't already set up on the visual.

 

When one option is being  sliced the data label displays. When multiple are selected, the total label seems to supercede the data label, working, as Turtle said, quite surprisingly.

timvs
Frequent Visitor

@TurtleToes @msaville did u manage to make it so that only the total label displays, even when multiple categories (in the legend) are being shown?

I only want to see totals, because having the data labels for each category (legend) enabled is too cluttered.

Microsoft please fix.

This widget could not be displayed.