on 12 Feb 2016 23:18:15
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
- Comments (50)
RE: dynamic axis scaling
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 :-)
RE: dynamic axis scaling
we need this feature as most of the user base is looking to use it as a dynamically.
RE: dynamic axis scaling
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.
RE: dynamic axis scaling
... after experimenting, in fact there does appear to be a "workaround" (but not full solution).
e.g.
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.
RE: dynamic axis scaling
Client specifically requested this feature in the solution.
RE: dynamic axis scaling
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.
RE: dynamic axis scaling
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.
RE: dynamic axis scaling
I want this
RE: dynamic axis scaling
This is something I have been waiting a long time for.
RE: dynamic axis scaling
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.