Forum Discussion

MattAllington's avatar
MattAllington
Community Champion
10 years ago
Solved

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.
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    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. :-)

     

MattAllington's avatar
MattAllington
Community Champion
10 years ago

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. :-)

 

PraveenRaj's avatar
PraveenRaj
Helper I
7 years ago

I have a Bunch of time series data, in line chart i want to remove the scroll bar, I cannot able to, set continuos state from categorial. It automatically comes back to categorial. Please help me to solve this.

 

Thanks

  • Vergilio_Sogabe's avatar
    Vergilio_Sogabe
    New Member
    6 years ago

    Please,

     

    have you find a soluttion?

    Tks

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    If I use MonthNumber, finally I could see the "Type" option for X axis, however i run into the same problem that it doesn't allow me to change it to continuous. It always go back to categorical. Thus I still have the scroll bar problem.

  • shubhendu_rana's avatar
    shubhendu_rana
    New Member
    7 years ago

    I was also facing the same issue. When I checked the data type of my time column in Power BI, it was text type. When I changed the data type to Date/Time and saved it, Now I am able to change the type to continuous.

     

    Steps to change data type:

    Go to Data tab on the left ribbon -> select time column in the table -> Go to the Modelling tab on the menu bar -> change datatype to Date/Time