Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Scroll Bar in graph

Hello everyone,   I have 2 reports, one which was made about 3 years back and then reports which have been made in the last year or so.   I have a scroll bar in my visual in the report made 3...
Need Help
Show and Tell
  • dhruvinushah's avatar
    dhruvinushah
    4 years ago

    Hi visheshjain , 
    You are right, the continuous and categorical options are deprecated, and instead been replaced by other options like the logarithmic scale: 

    In regards to your original problem of the Visual not having a scroll bar, I believe that's due to the data for the 3 years from Jan 2020 to July 2022 fitting in that space. I tried to manipulate a similar behavior in a test file and see what caused and created the scroll bar on a Clustered Column Chart. The only thing that seemed to affect the presence of a scroll bar is the overall size of your Visual chart and the spacing between the columns / bars of your visual. If you increase the size of your bars / columns, you will see that the visual will need more space and automatically include a horizontal scroll bar to that effect. 

    Unfortunately the only way right now to "fix" the presence of scroll bar is to manipulate the "Spacing" setting in the "Column" format settings. 

    Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
    Thanks!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ok visheshjain - I believe the only values and dates can be used in Continuous ranges.  If you have a text value e.g. ("Aug-2022"), it will treat the dimension as "Categorical" and sort using the Sort key.  To create the date version of "Aug-2022" you need to use the start or end of month (i.e. 01/08/2022).  Then the trick is to format the column in the Data Model settings (the advantage of this approach is that sort column is now unnecessary):

 

 

 

  • visheshjain's avatar
    visheshjain
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Hi Anonymous,

     

    Converting the column to a date would defeat the purpose of having the MMM-YYYY format.

     

    Also, if you see in my question, I have the same MMM-YYYY format in the graph along with the scroll bar.

    So I can't figure out why is it still showing up in the old report and not in the new one.

     

    Thank you,

    Vishesh Jain