Forum Discussion

wonka1234's avatar
wonka1234
Icon for Helper III rankHelper III
11 months ago
Solved

Stacked Column, Squeeze All Bars into chart without showing horizonal scroll

hi,

 

is it possible to fit ALL values/bars into my stacked chart WITHOUT showing the horizontal scroll? I need to squeeze lines in.

 

Thanks.

  • Hi wonka1234,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you ArwaAldoud and FBergamaschi for the prompt response. 

     

    No you cannot make stacked column or bar charts to show all text categories without the horizontal scroll, the chart will always add it if there are too many items. Power bi reserves a minimum width per category for categorical axes.

    If your x-axis is a date or numeric field you can switch the axis type to Continuous and use a line or area chart these can display many more points without scrolling.
    If the axis is text the stacked column visual will always use categorical spacing, so use horizontal stacked bar chart instead, able to scroll vertically and longer labels fit more easily.

     

    Thanks and regards,

    Anjan Kumar Chippa

7 Replies

  • Hi wonka1234 

    You can’t fully turn off the horizontal scroll when there are too many categories, but you can make more room by:

    • Reduce the font size & adjust visual padding

      Go to Format pane > X-axis > Text size and lower it.

      Under General > Padding, reduce the inner and outer padding to fit more bars.

    • If your X-axis is a date/time field, set the axis type to Continuous instead of Categorical. This usually fits more values without scrolling.
    • Also try Increase the width of your chart.

      Under X-axis > Concatenate labels, turn it off and rotate the labels (e.g., 45° or 90°) so more categories are visible.

    If this response was helpful, please accept it as a solution and give kudos to support other community member.

    • wonka1234's avatar
      wonka1234
      Icon for Helper III rankHelper III

      ArwaAldoud 

       

      1) already have it on DIN size 8

      2) non dates

      3) Not sure if i can rotate labels. I dont see that option. i am using power bi Version: 2.142.1277.0 64-bit (April 2025)

  • I believe you cannot to that on bar charts but you can surely do that on a line chart as there you can have a continous x axis and not a categorical one. This is by definition impossibile on bar charts as they are native categorical

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi wonka1234,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you ArwaAldoud and FBergamaschi for the prompt response. 

     

    No you cannot make stacked column or bar charts to show all text categories without the horizontal scroll, the chart will always add it if there are too many items. Power bi reserves a minimum width per category for categorical axes.

    If your x-axis is a date or numeric field you can switch the axis type to Continuous and use a line or area chart these can display many more points without scrolling.
    If the axis is text the stacked column visual will always use categorical spacing, so use horizontal stacked bar chart instead, able to scroll vertically and longer labels fit more easily.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support

      Hi wonka1234,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Icon for Community Support rankCommunity Support

        Hi @wonka1234,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa