Miguel Myers on 08 Oct 2024 05:00:00
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.
- Comments (53)
- Merged Idea (1)
RE: Epic idea: Advanced secondary axes
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?
RE: Epic idea: Advanced secondary axes
Would be great to have the option of dynamic axes on charts for better visualization of graphics.
RE: Epic idea: Advanced secondary axes
this option is not working we cnat set the y axis scale, this featured should be applicable for all the charts.
RE: Epic idea: Advanced secondary axes
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: Epic idea: Advanced secondary axes
we need this feature as most of the user base is looking to use it as a dynamically.
RE: Epic idea: Advanced secondary axes
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: Epic idea: Advanced secondary axes
... 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: Epic idea: Advanced secondary axes
Client specifically requested this feature in the solution.
RE: Epic idea: Advanced secondary axes
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: Epic idea: Advanced secondary axes
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.