Forum Discussion
Invert Y line axis
What I currently have:
What I actually need:
But as percentages on the secondary axis. I've achieved the image above by multiplying my column by (-1), but when showing the values as a % of the total it just returns the first image. I want the above image but with percentages instead of those negative numbers.
You can achieve this by multiplying the % measure by -1. You then customize the format for the measure in the modeling pane by setting the format to be the same for both positive and negative values (see image).
9 Replies
You can achieve this by multiplying the % measure by -1. You then customize the format for the measure in the modeling pane by setting the format to be the same for both positive and negative values (see image).
Thank you, your solution worked! but there's a problem, the scale on the right ends up looking like this:
With the values going from 100 up to 0, when what I intended was for it to go from 0 to 100
Here's how it looks in Excel (And how it was supposed to look):
Your answer solves the problem posed in the question, but is there a way to get the result shown above in Power BI?
What measure are you using? If it's a cumulative value, how is your model set up and what are you using in the X-axis?
Something similar to yours, your charts also presented the same quirk.
Sorry, I'm not following what you are trying to achieve.
Here are the two visuals side-by-side: one has the axis from 0 to 100%; the other from 100 to 0%
So if it's neither of these, what do you need?
