Forum Discussion
Solved
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 %...
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).
I needed this:
Which I've since achieved with the custom visual "Pareto by sio2Graphs", though it would be nice to have achieved it without the use of a custom visual.
You can achieve this using the default clustered column and line chart
You just need the measure for the cumulative %
Thank you, I thought the method I was using would work, but clearly it doesn't.
Care to share your measure?In my case, the model would be:
and the measure:
Cumulative % = VAR _Cumulative = CALCULATE ( [Sum of Sales], FILTER ( ALLSELECTED ( 'Calendar Table' ), 'Calendar Table'[Month] <= MAX ( 'Calendar Table'[Month] ) ) ) VAR _All = CALCULATE ( [Sum of Sales], ALLSELECTED ( 'Calendar Table' ) ) RETURN DIVIDE ( _Cumulative, _All )