Forum Discussion
Remove Scroll Bar in Clustered Column Chart
The options has different granularities.
The only was is to make more space for the visual or filter down the amount of values to display.
- Anonymous7 years agoNot applicable
Thanks for the reply Anonymous, however i undertand that making more space for the visual would show all the columns without the scroll bar, but that defeats the purpose of what i am trying to achieve. Also, if i filter down the values (which i assume you mean on the x-axis), this will display the incorrect data, as i am trying to return the previous 52 Fiscal Week from todays date.
The result i am looking for is doable in Excel, hence i know a solution must exist in Power BI. When i add Fiscal Week to the X-Axis, it now displays everyhting without a Scroll Bar after changing it from Data Type: String to Numerical. However, as you can see from the below image, as i have selected Continous, it now introduced a new challenge of filling in the gaps between Fiscal Week 1852 and 1901, when in fact it should.
Hope this explains it more. In fact, i will update my intial post with more detail in order to explain it all better :)
Thanks,
Laz
However, as you can see now,