Forum Discussion
Remove Horizontal Scroll Bars?
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. :-)
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. :-)
I have this graph that displaying 12 month rolling average from 2009 to current (2019 Jan).
Left graph:
If I choose Calendar[Year] and Calendar[Month] in x axis, then the last month is current month (Jan 2019), however then it has scroll bar and can't fit into the small region where I wanted it to be. And in the format--x-axis, there is no selection on continuous or categorical to choose.
Right Graph:
If I choose Calendar[Date] in x axis, and hierarchy year and month, yes I can choose continuous and make it without scrollbar, however my problem is then the x axis will show extra month beyond today's date. It has these extra invalid datapoints for 2019 Feb, 2019 March etc.
I just want have something like ont he right graph, but not showing the invalid rolling average datapoints after current month.
Any suggestion? Thanks.
Hey, have you found solution for this?
