dynamic axis scaling
Option to allow dynamic axes on charts - allow an option in chart setup to allow the axies to change dynamically based on the values within - the start and end of an axis are fixed, despite values changing when filters are applied
Estêvão Zica commented
It would be awesome to have this dynamic feature on y axis so we could highlight smaller variances better!
Very much wanting this!
Holger Hagedorn commented
Currently y axis Start end End values have to be entered manually. I need an option to enter a measure as start / end value.
This feature is much needed for the waterfall chart. Without it you can't really tell what is going on as you change time perspective.
James A. Dalla Santa commented
I have created a working solution of this in Excel - VBA, which allows the graph to keep its focus on the variance between the 20th and 80th percentile. If you have a monstrous number the values between zero and the lower bounds of your data really mean nothing for analysis.
I agree. This kind of crap is what makes me want to go to Tableau. We have both in-house. Two years in and still no comment from MS regarding this.
Rashmi Ravi commented
When can we expect this feature on Power BI?
Just to add more details to my earlier points below, the dynamic y axis only works for Line Charts. That is, if you use combo charts with column and line graphs, only the line chart will dynamically scale as you drill down.
So if I'm at the highest level using column chart and manually adjust the scale to start from 300 million, to help reveal trends between 300 to 400 Million, then if drill down into smaller region amounts, the y-axis still starts at 300 Million which means I can't see the data below this value.
Whereas, if I use a line chart, manually adjust the start value, then drill down, the axis will dynamically reset.
Not sure why Line Chart behaviour can't be replicated with other types of charts?
Would be great to have the option of dynamic axes on charts for better visualization of graphics.
this option is not working we cnat set the y axis scale, this featured should be applicable for all the charts.
Allowing axis start/end to use a Measure as input would provide so much power to the report designer – I would really like that to be implemented :-)
Karan Sehjpal commented
we need this feature as most of the user base is looking to use it as a dynamically.
... after experimenting, in fact there does appear to be a "workaround" (but not full solution).
If you set the start value for the Y-axis at 200M at the highest level (hierarchy) you can better see variations if data was between 200M - 280M.
When you drilldown into lower levels (e.g. 0 - 10M) the y-axis start value automatically defaults to 0.
So you can get that detail at the higher levels & live with auto scaling at the lower levels.
I'm not sure if this problem has been highlighted properly or if indeed there is a workaround.
Specifically, there should be an option to dynamically offset the start value for the Y-axis.
Currently Power BI will scale the maximum value as we drilldown but will always start at zero (despite all data being at least 75% of the total).
So you can't see the detail (or trends) at the higher levels where it's needed.
You can't manually enter start value because that won't scale to lower levels and the Log scale doesn't seem to help either.
Not sure why there isn't more votes on this. Should be an easy (but important) fix.
Mike Donnellan commented
Client specifically requested this feature in the solution.
Jani Liimatta commented
This, as well as all the other properties in Power BI, should have expressions behind. Fixed starts and ends don't work in real life.
Tinh Nguyen commented
Please add a feature that allows individually setting axis scaling/intervals for each drill down level. For now, settings apply to all drill down level.
Roy Morris commented
I want this
This is something I have been waiting a long time for.
This is definitely a must-have - the ability to use a formula to automatically change the scale of the Y axis (so you can control the maximum and minimum scale rather than using either a fixed start/end or the current automatic scale that doesn't create very dramatic chart presentations.