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

Something similar to yours, your charts also presented the same quirk.

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?