October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi All,
I'm wanting to use Power BI for Google Analytics and website ranking reports.
One of the crucial parts that I'm struggling with is the Rankings line graph. Basically, in order to make the graph look positive, I need to invert the Y axis so that 0 is at the top and 100 is at the bottom. (A position of 1 is the best)
I can't seem to find any way of doing this.. In Excel you would simply reverse the axis but this option doesn't seem to be available in PowerBi.
Could anyone advise on how this could be achieved?
Thanks in advance.
Solved! Go to Solution.
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.
Thanks, @memocyp I did that already just was asking if there is any update. On the inverted Axis, BTW the link is not working for the ideas anymore.
Best,
Jorge
I'm struggling with this too, seems to be a missing feature.
The only workaround I can think of is to create a measure that reverses the rank order then turn off the axis label. Not ideal but at least the graph should look right.
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 guys,
Are there any updates on this? The feature still doesn't seem to be available and the idea page seems to have disappeared and I am unable to vote.
Thanks,
Has this been solved yet I want to start on 0 and have the top y at -4000
Just adding my vote that the ability to invert/reverse the Y axis on a Line graph is critical for analysis that we are performing too.
thanks
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |