Forum Discussion

dlopesc044's avatar
dlopesc044
Frequent Visitor
3 years ago
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 %...
Need Help
Show and Tell
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    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). 

dlopesc044's avatar
dlopesc044
Frequent Visitor
3 years ago

Thank you, I thought the method I was using would work, but clearly it doesn't.
Care to share your measure?

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

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 )