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