Forum Discussion
"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
6 Replies
- Greg_Deckler
Community Champion
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.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
Resident Rockstar
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_DecklerM has a List.Reverse function, https://msdn.microsoft.com/en-us/library/mt260764.aspx that you could potentially use to create a column with "reverse" values and set the Sort By by that.
