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
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • 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.