Forum Discussion
Problem with sorting years in Waterfall Chart
gserbezov what you need to do is go to Data view and select your table. Select Y Axis field of waterfall chart and click on Sort By Column dropdown. Then select Category field of waterfall chart (which will be Year in your case). This will sort sales variance by year.
ankitpatira I tried your way, but still not working. The Sales variance is a calculated measure and it can not be sorted, so I tried with the Revenue field, which is in the same table and it`s used for calculating the Sales Var, but then the Year(Category field) is in another table and it is not in the sorting drop down for Revenue, so I checked the relationship and the Date table is connected with the Sales table by the Date field. I tried to sort the Revenue by Date field but then an error message pops up and says that it`s not possible.
DateSales VarianceError message when try to sort Revenue by Date
Instead of measures, can you try to use a calculated table? The sorting works in the calculated table.
If you have any question, feel free to let me know.
