Tried setting up the Sort by Column but my table and charts still didn't sort properly. I followed the steps and the YearMonthInt formula worked. What am I missing?
An elegant solution is to create a date bin. You do this by
Wow, I'd been looking what felt like everywhere for an answer to this problem, somehow no other site or video suggested that trick of multiplying the year by 100, that's what made it work for me. More than three years after you wrote the post, too. Thanks!