Forum Discussion

gserbezov's avatar
gserbezov
New Member
10 years ago

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...
Need Help
gserbezov's avatar
gserbezov
New Member
10 years ago

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

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

gserbezov

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.