Scroll Bar in graph

[visheshjain]

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 years back, which is working to this day.

However, the reports made recently do not show the scroll bar and it keeps on fitting everything on the x-axis to that confined space, which makes the visual difficult to read.

Has a scroll bar

Made 3 years back and has a scroll bar

Does NOT have a scroll bar

Made 2 months ago, does not have a scroll bar

I have checked the visual type and every setting possible in the visualization.

Also I cannot see the continuous and categorical options in the X-axis either.

Please can anyone advise what is going on and/or has the product/engineering team made any changes.

Thank you,

Vishesh Jain

[dhruvinushah · Accepted solution]

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!

[visheshjain]

Hi @dhruvinushah,

I did try to tinker with the spacing, but initially it did not work.

After your suggestion, I increased the spacing the column size to quite a large size and viola, I got the scroll bar.

Thank you for responding.

Vishesh Jain

[Daryl-Lynch-Bzy]

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]

Hi @Daryl-Lynch-Bzy,

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

[Daryl-Lynch-Bzy]

Hi @visheshjain - okay that is odd.  This is what I am seeing in the Aug-22 version.  A couple of consideration:

• It a Custom Visual?
• Is it not "technically" a Date dimension, you are using.  Could it be text, or a non-date table date field?

[visheshjain]

Hi @Daryl-Lynch-Bzy,

No it is not a custom visual.

It is a text column, but it is from my calendar table and sorted using a Year Month Key.

My calendar table is 'Marked as Date Table' as well.

The same thing is done in my old file as well, and the scroll bar shows up.

I have checked with my old file as well, which has a scroll bar, even in that in the formatting pane I cannot see categorical and continuos options.

Thank you,

Vishesh Jain

[Daryl-Lynch-Bzy]

Hi @visheshjain - Here are couple of previous discussion about the use of Categorical vs Continuous x-axis setting an how it determines if the scroll bar is available.

Solved: Scroll bar in chart - Microsoft Power BI Community

Solved: Remove Horizontal Scroll Bars? - Microsoft Power BI Community

[visheshjain]

Hi @Daryl-Lynch-Bzy,

Thank you for responding.

I already saw the posts and I am unable to find the options for 'continuous' and 'categorical' in the X-axis options.

I am using the Aug 2022 version.

If you can find the settings in the latest update, please do share the information.

Thank you,

Vishesh Jain