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
Community Champion
3 years ago

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?

dlopesc044's avatar
dlopesc044
Frequent Visitor
3 years ago

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.

  • PaulDBrown's avatar
    PaulDBrown
    Community 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
        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 )