Forum Discussion
Remove Horizontal Scroll Bars?
Is it possible to prevent Power BI adding horizontal scroll bars to a chart? I really hate the scroll bars. I want to put the items on the X axis and have them all visible - just like in Excel.
Thanks for your reply. What threw me was I was watching this video from sqldusty and at 29:40 min/sec into the video, I saw a chart that fit everything on the axis without a scroll bar. I had never seen that before as all of mine are always impacted by a scroll bar. https://www.youtube.com/watch?v=0TF4Hu-uaMg
What I now understand is that when you select continuous axis, it DOES fit everything. When you select categorical it adds a scroll bar (when there are "too many" data points).
My problem is I am using Labels for my week dates in the format YYWW. Now I know what I am looking for, I have swaped these labels to the week ending date and changed the chart to continuous - and now it works as I would like. :-)
13 Replies
Hi Matt
As I understand it the Power BI canvas is fixed depending on the resolution of your screen so a scroll bar will appear if the data cannot fit unto you screen. Some elements will allow you to resize the font giving you the opportunity to fit it on the screen but not all and if they don't you cannot remove the scroll bars.
I might be wrong but that is how I understand it.
Ásgeir
Thanks for your reply. What threw me was I was watching this video from sqldusty and at 29:40 min/sec into the video, I saw a chart that fit everything on the axis without a scroll bar. I had never seen that before as all of mine are always impacted by a scroll bar. https://www.youtube.com/watch?v=0TF4Hu-uaMg
What I now understand is that when you select continuous axis, it DOES fit everything. When you select categorical it adds a scroll bar (when there are "too many" data points).
My problem is I am using Labels for my week dates in the format YYWW. Now I know what I am looking for, I have swaped these labels to the week ending date and changed the chart to continuous - and now it works as I would like. :-)
Just want to say "Thank you" to Matt. This was driving me NUTS. I had one line chart that I simply could not get it to display all x axis data without a scroll bar.
It was a pain, but I ended up changing my column of "Week 1, Week 2, Week 3, etc, data points to actual dates. Re-uploaded the data, changed the X-axis to continuous and WALAH! This really should not be this complicated to adjust.
Thanks again
Hi all,
I am facing a similar problem as I would like all my data to be visible without having to use the scroll bar. Unfortunately, in my case I am not using dates on the X-axis but I am using a categorical variable which lists locations. Does anybody have another idea how to solve this issue when you can't transform the variable into a continous variable?
Thanks in advance for your help
MattAllington Hi Matt, have you found the way to fit the data in line chart just like in excel despite the resolution or using other methods? Please share if you have found a way, thanks.
Was your X axis now Week 1, Week 2 etc.. or just dates? Is there any way to prevent the scroll bar for categorical data?
I have a combination of Month & Working day.. I'm comparing data for mulitple months in one chart so have to create a field like this.
