Terje Fjeldstad on 28 Jan 2015 15:45:24
It should be possible to have an "invert axis values" when defining Charts. In some cases, let's say School grades, the grade 1 is the best and 6 is fail. in this case, I would like to show an y-axis starting on 6 and ending on 0.
Administrator on 21 Jul 2021 16:46:41
The ability to invert the Y axis exists today within the format settings.
- Comments (17)
RE: Invert axis display values
There is an alternative solution idea.
1)Multiply the original number by -1 to create a new measure
2)Apply a "custom" format. For example, -#;#;0
RE: Invert axis display values
Any update? Using ranking data need 1 to be up the top. This is basic functionality and should have been implemented in the first place. Shame on you for assuming data only goes one way.
RE: Invert axis display values
you can invert your measure:
Create new measure and use current measure multiply (-1)
RE: Invert axis display values
Think of star magnitudes, where the brightest have even negative values. One could of course (-1) them, but then the measure is plain wrong.
RE: Invert axis display values
Yes please!
RE: Invert axis display values
Yes Please! Also ignore null or zero values!
RE: Invert axis display values
Totally agree with the very first comment after 2 years.
Please, Microsoft. Please.
> Basic Excel Functionality. Please Implement.
RE: Invert axis display values
How is this not a thing yet? It's been TWO YEARS
RE: Invert axis display values
please, please, please implement this
RE: Invert axis display values
Please Implement this