Forum Discussion
Super UserShowing all data in line chart without scroll bar
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
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
Super UserHi 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
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
