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
dmgutenkauf's avatar
dmgutenkauf
Regular Visitor
10 years ago

I had this issue today. It seems to be a case where Power BI gets "stuck" somehow. While trying to fix it, I changed the chart to a table, resorted by the category column (even though the table was already sorted correctly), and when I changed back to the waterfall the sort was fixed.

 

Now that it's fixed, I can no longer recreate the initial issue... go figure.

 

Hope this works for you too, or anyone else who stumbles on this!

  • PetaG's avatar
    PetaG
    New Member
    8 years ago

    I've had the same problem. Tried your fix (created table & Matrix & sorted on year), but with no luck when I went back to the waterfall.

  • PetaG's avatar
    PetaG
    New Member
    8 years ago

    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

    • bazicalos's avatar
      bazicalos
      Advocate I
      7 years ago

      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.