Forum Discussion
Invert Y axis in scatter chart
Is there a non-coding way to reverse y axis on scatter chart? My values currently go from lowet to highest values but I want it inverted for the lowest ones to be on top.
3 Replies
- VasTg
Memorable Member
There is no direct way to invert the axis values.
Refer to these posts.
https://community.powerbi.com/t5/Desktop/Invert-Y-Axis/td-p/6721
https://community.powerbi.com/t5/Desktop/Invert-Y-Axis-on-Line-Graph/td-p/655412
https://community.powerbi.com/t5/Desktop/Invert-Reverse-Axis-on-Line-Chart/td-p/597891
https://community.powerbi.com/t5/Desktop/Invert-x-axis/td-p/422569
If it helps, mark it as a solution
Kudos are nice too
- PaulDBrown
Community Champion
There is a way, but it involves creating a new measure to render your values negative: [your measure]*-1
here is an example related to creating a visual where the rank values need to be inverted to make Rank 1 the "highest" etc...
1) Displaying a rank value in a visual renders the "top" rank appear at the bottom
2) Multiplying by -1 solves this, but then values are displayed as negative:
3) to solve displaying values as negative numbers, you can format the measure to display + values in the modeling pane, selecting the measure and using the custom format options:
- v-lili6-msft
Community Support
hi Krcmajster
For scatter chart visual, you could use Measure*-1 as a workaround, and for line chart visual, you may refer to this post as below:
https://community.powerbi.com/t5/Desktop/Rank-Visual-over-time/td-p/864768
Regards,
Lin