Forum Discussion
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
- ArwaAldoud
Super User
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
Helper III
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)
- Reduce the font size & adjust visual padding
- FBergamaschi
Super User
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
Community 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
Community 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