I’m looking for assistance in re-ordering on the months on the X axis of a graph please.
My financial year runs from April - March and I’ve got actual data from April - October with budget data from April - March. When I display the data on a standard bar chart by month comparing actuals to budget, the graph shows Jan - Mar as the left most months on the X axis when I want them showing as the right most i.e. appearing after December.
I’ve used the Date table that is provided in the beginner learning series and have redone my FY quarters as per the YouTube clip on that topic. I’ve tried creating caluated columns and using Power Query on the date table to get the graph to display correctly but I appear to be failing miserably!
Any help would be hugely appreciated.