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
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.