Forum Discussion
Total Labels Disappear on Stacked Column Chart with Specific Slicers
Hi,
I’m working with a stacked column chart that uses fields on the X-axis, Y-axis, and a Legend to break down each column. I’ve also added several slicers to filter the data.
Here’s what happens:
When I apply certain slicers, the “Total labels” appear correctly above each bar.
However, when I filter using other slicers, the total labels disappear—and the “Total labels” option in the Format pane becomes grayed out whenever the chart is filtered by those particular slicers.
This is very confusing, and I haven’t been able to find the cause.
Any help would be greatly appreciated!
Thanks
Hi amir_mm,
I guess, Stacked column Total labels only works when you have two or more segments in your stack. As soon as a slicer reduces to a single value then it disables the total-label feature.
I tried to create a DAX measure to recreate the situationa and come up with a DAX to handle the situation.
Total Labels Disappear on Stacked Column Chart with Specific Slicers.pbixIf this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks!
Best Regards,
Maruthi
3 Replies
Hi amir_mm,
I guess, Stacked column Total labels only works when you have two or more segments in your stack. As soon as a slicer reduces to a single value then it disables the total-label feature.
I tried to create a DAX measure to recreate the situationa and come up with a DAX to handle the situation.
Total Labels Disappear on Stacked Column Chart with Specific Slicers.pbixIf this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks!
Best Regards,
Maruthi
Thanks for checking.
Yes, I noticed that when only one legend item is selected, the stacked bar chart doesn’t show the total labels. Instead, we can use data labels in a Line and Stacked Column Chart as a workaround.
Thanks again.
Hi amir_mm It is likely due to slicers filtering out all data or creating BLANK values in the chart, which disables total labels. Ensure slicers don’t exclude all data and verify relationships in the Model view to ensure proper filtering. Adjust custom measures to handle BLANK values with DAX like IF(ISBLANK(...), 0, ...). Check slicer interactions under Edit Interactions to avoid unintended behavior.
