Financial Month

[narasimhuluk]

Hi Folks 

i want to display month 

Month

Apr,May,.........Jan,Feb,Mar

but i have month fields 

text month :  alphabeticall order   Apr, Aug, Dec ......Nov

calendar month : Jan , Feb ...Dec

pleae suggest me  ways to to display my month from Text , Calendar month to financial month 

Thanks 

[Michiel · Accepted solution]

Provide a month number column in your date table next to the month name, and have it start with 1 for April, 2 for May, etcetera. Then use the Sort by Column option (Modeling tab in Power BI Desktop's Data view) to sort the month name based on the new month number column.