Forum Discussion

Emma_'s avatar
Emma_
Icon for Helper II rankHelper II
1 year ago
Solved

Additional Details Data Labels - Stacked Bar Chart

Hello, I am using Details Labels to display % on my stacked bar chart, however they do not appear on each bar. I tried to play with font size, resizing the chart and some other settings, but didnt find anything to fix this. Does anyone know this issue? Thank you.

 

  • Hi Emma_ 

    It's unusual that your labels aren't displaying, as your bars don't appear too narrow to accommodate text, and you've already enabled multi-line formatting. Let's try these solutions:

    Immediate Fixes

    Reduce Font Size

    • Go to: Format pane → Data labels → Text size

    • Try decreasing to 8-9pt (smaller fonts often display when larger ones won't)

    Alternative Chart Types

    If issues persist:

    • 100% Stacked Bar Chart

      • Focuses purely on percentages (ideal if relative composition is your goal)

      • Labels auto-align better in this view

    • Line + Stacked Column Combo

      • Place percentages on a line chart above bars

      • Eliminates label crowding entirely

    Advanced Checks

    • Verify no filters are hiding small segments (Check "Show all" in label settings)

    • Ensure measures return valid values (BLANK() results suppress labels)

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

4 Replies

  • Hi Emma_ 

    It's unusual that your labels aren't displaying, as your bars don't appear too narrow to accommodate text, and you've already enabled multi-line formatting. Let's try these solutions:

    Immediate Fixes

    Reduce Font Size

    • Go to: Format pane → Data labels → Text size

    • Try decreasing to 8-9pt (smaller fonts often display when larger ones won't)

    Alternative Chart Types

    If issues persist:

    • 100% Stacked Bar Chart

      • Focuses purely on percentages (ideal if relative composition is your goal)

      • Labels auto-align better in this view

    • Line + Stacked Column Combo

      • Place percentages on a line chart above bars

      • Eliminates label crowding entirely

    Advanced Checks

    • Verify no filters are hiding small segments (Check "Show all" in label settings)

    • Ensure measures return valid values (BLANK() results suppress labels)

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

  • Hi Emma_ ,

    Did you try Layout as multiline and Detail as Percent of Total?

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

     

     

    • Emma_'s avatar
      Emma_
      Icon for Helper II rankHelper II

      thanks for reply. yes, it is set up as multiline already.