Epic idea: Advanced secondary axes

[Miguel_Myers]

Secondary axes are automatically managed by the system in some cases, making it problematic for report creators with no control over intervals, ticks, and other crucial components, limiting effectiveness of various types of analysis. It would be great if the secondary axis included comprehensive format settings so that greater control over displayed data is provided.

[dhannon1]

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.

[peterwallace1]

This is something I have been waiting a long time for.

[soundwave123]

I want this

[tinh_nguyen1]

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.

[jani_liimatta1]

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.

[ehage]

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

[MikeDonnellan]

Client specifically requested this feature in the solution.

[ehage]

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.

[anamm2]

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]

we need this feature as most of the user base is looking to use it as a dynamically.