Forum Discussion
Dynamic Y-Axis on Line Charts
When creating an Line Chart using small multiples you can have several charts showing up within the "canvas" area of the line chart. Unfortunately the Y-Axis always set to the upper and lower bounds thus when you have disparate scales of really large and really small amounts the small values appear as a straight line, when in actuallity if the scale were smaller you would see a large dispersion between the minimum and maximum value.
3 Replies
You can use the zoom slider on the Formatting pane for this so that the chart can be zoomed to the section you need to look closer into.
The zoom slider is not available is you have multiple charts displayed for a line chart visual.
In line chart you can get mulitple charts in the canvas area by supplying another grouping measurement in the Small multiples field. What you end up with is multiple charts in the visual that have a common axis. The problem is that the Small Multiples field can have very disparate scales that make them unusable because the large scale will make the small scaled charts look like a flat line. See the inputs for the fields and formats
Please notice the grid layout that now appears where the zoom slide would appear for a single chart
The chart with values in the Millions complete skews the axis for the chart with values in the 10s
I would be nice to use the function on the y-scale to use the min and max of the individual chart and not the min and max of the overall data. The min and max should be determined by the small multiples grouping value.
Hi BrandonCampbell ,
According to your description. I tried. But there is no this feature for the time being, you can create an idea to help improve power bi
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
