Forum Discussion
Problem with sorting years in Waterfall Chart
Hello everyone, I have a problem with the waterfall chart. I would like to visualize a sales variance by year in a waterfall chart, but when I put the Year in the category field, on the visualiz...
Hi, same here - my years go from current on the left to 2000 on right hand side.(back to front)
I tried your workaround (created table & matrix, then back again) to no avail.
I also tried someone elses suggestion & recreated, making sure year field was placed last - no good.
Has anyone in the community got any further suggestions.
thanks
Faced the same problem. Handled it with the help of Microsoft Docs article.
In short here are the steps:
1. Call chart menu pressing [...] button on the top right of the chart
2. Proceed to "Sort by" item
3. In submenu press "Year" item. The order should be correct now
4. If the Y-axis is shown upside-down, go to the same menu and press "Sort accending"
This worked for me.