Forum Discussion
Solved
Order column chart by month over multiple years
I'm trying to order the columns by month over a financial year that starts in May and finishes in April.
Most examples I have come across only deals with January to December scenarios.
Any ideas how I can do this?
Formula should be:
Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)
Thanks, that does it :-)
10 Replies
First, you need Date table.
Second, you need to create a column FYMonthNum and assign value 1 to May, value 2 to June, and so on until value 12 for April.
Third, you need to apply that Month column is sorted by this newly created column FYMonthNum.
If you have done all this, then in the visual month should appear correctly from May until April.