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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

You can achieve this using the default clustered column and line chart

You just need the measure for the cumulative %

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
    Icon for Community Champion rankCommunity 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 )