Forum Discussion

kfransis's avatar
kfransis
Regular Visitor
10 years ago

"Values in reverse order" in Line chart

can we format the x axis in line chart to show in reverse order?  just like "Values in reverse order" function in excel
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago
kfransis - So, what you can do is to create a new calculated column and do something like (making up numbers) = 3000 - [Value] and then set the Sort By column for your x-axis column to this new custom column.
kfransis's avatar
kfransis
Regular Visitor
10 years ago

Thanks for the prompt response...

 

I have tried to reverse the data but it still does not work for me.

 

What I am trying to do is to start the "Y" axis with the lowest number. (see picture)

 

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    To my knowledge this isn't possible. The only way to get this would be to create a custom visual or to negate your measure value to plot negative numbers on the standard line chart.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    kfransis, I agree with greggyb, sorry, when you first stated the issue, you mentioned the x-axis which in certain circumstances you can control by sort order. But the y-axis I am not aware of a way to do this, in fact, if you try to set "end value" lower than "start value" in the paint brush, it does not like it and gives you a red outline and does not set it.

     

    Would be a good thing to post in Ideas if not there already.

    • kfransis's avatar
      kfransis
      Regular Visitor
      10 years ago

      Greg_Deckler: Sorry about the confusion...but thanks for all the feedback and comment. much appreciated that.