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
Any update ???
RE: Epic idea: Advanced secondary axes
You can duplicate the visual, adjust the scaling, then create a bookmark with the duplicate visible and the original hidden. You can then use +/- icons to switch between the two. It can be made to look fairly seamless, however it's still ridiculous that dynamic axis scaling still hasn't been implemented and report users and designers have to use such a workaround.
RE: Epic idea: Advanced secondary axes
This has been requested by my client and it would be a great enhancement. Does anyone have a workaround?
RE: Epic idea: Advanced secondary axes
I have a basic monthly headcount for our company - numbers across months in the 2500 range, we also have 9 regions that I have slicer for.
I want the Company level to show the variance more clearly so set the y axis scale to a smaller range, but this doesn't work when the region slicer is used due to the headcount being below the company level pre set scale.
I'd be really useful if I could set the y axis scale range by a % of the existing data i.e. x% above highest value in the data set to x% below so it changes consistently across non filtered and filtered data sets versus current functionality of fixed numbers.
RE: Epic idea: Advanced secondary axes
Any update on this feature?
RE: Epic idea: Advanced secondary axes
Perhaps just as important is the ability to dynamically switch from 0 end to -1 (lowest value) end. Sometimes you want to see the whole magnitude, sometimes you want to focus on the changes. Would love to be able to do with with a formula.
RE: Epic idea: Advanced secondary axes
Any update?
RE: Epic idea: Advanced secondary axes
Any progress on this? Having to manually adjust charts is painful and looks unprofessional
RE: Epic idea: Advanced secondary axes
It can be very misleading having a bar and line graph with two different scales.
Even though we can align zero’s on the Y scale, if one scale is different than the other, wrong conclusions are derived from the analysis. One might think that positive values compensate the negative ones when in reality they’re just a fraction of the value.
RE: Epic idea: Advanced secondary axes
Has this been resolved? I don't see an updated feature yet which incorporates the idea here. This is a very important feature found in Excel!!!