Forum Discussion
Invert Y Axis
Hi,
There is currently no option to invert the Y axis in your chart. Best workaround would be to multiply your values by -1.
Please leave a vote for this feature in our UserVoice forum:
https://support.powerbi.com/forums/265200-power-bi/category/91861-desktop
Thanks,
M.
Hi,
I found a solution to this problem.
To make the graph look positive , we can make a measure for the values and then multiply it with -1.
Then download a "multiple axis chart - XViz" and drag your measure into the values section. This will display an inverted chart but will show the data as negative values.
To change this go to number format and turn on semantic formatting.
Change the negative value format and positive value format to (X). You can change their colours as well. This will now show the values without the negative sign.
Regards Aman
Thank you. the -1 multiplication was normal but changing the representation was clever. Thanks. Its not a solution but its good enough while we wait ( somewhat impatiently ) for a product fix. Thanks