Showing all data in line chart without scroll bar

[DataNinja777]

Hi Power BI community,

I'd like to present line chart of movement over the past 10 years for year-month granurality.  However, horizontal space is not enough and horizontal scroll bar appears even though it is unwanted. I don't need to see all the year month (could be every other year-month), and I'd like to get rid of the horizontal scroll bar.  Please could anyone let me know how I can modify the visual to show the whole picture without an awkward horizontal scroll bar?  

Thanks for your help.  

[Ritaf1983]

Hi @DataNinja777 
There is no option to change the proportions of the charts and pixels that they need except for the minimum category which you can only modify to larger, not to smaller.
The steps that you can apply as alternatives :

1. Use a continuous axis instead of a categorical"

2. Resize the canvas width to the pixels that you need for all 120 points of 10 years:

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[DataNinja777]

Thank you @Ritaf1983  for the instruction.  

By tinkering with canvas section, I managed to get rid of the scroll bar by widening the horizontal length.  

In my line chart visual, the selections do not seem to be same as your 1st screen print, and I couldn't see the "continuous axis".  

My remaining issue is that 

I'd like to get the mmm-yyyy granurality line chart while only showing the year label as showing all mmm-yyyy will be too clattered looking.  

Thank a lot for your help!

[Ritaf1983 · Accepted solution]

Hi @DataNinja777 
Unfortunately, we can't show on /off or have different formats for hierarchy levels for the graph axes.
So there is no option ti "hide the labels".
2 alternatives ( as usual 🙂 )

1. Instead of using the automatic hierarchy, use the year column and month column, it less pixels so it will look much better :

2. you can hide it in a White shape...but if the user needs to drill up / down it can be a problem:

Result :

The pbix with both options is attached.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly