Date Format

[KimW]

Hi, how do I get my Months to show in order of my calendar on my Line chart?

Specifically the my calendar is designed to have the first month be the 10th month 

[ERD]

@KimW , another way is to use Power Query as the first step:

But then you will still need to Sort your Month Name column by this Fiscal month column.

[ERD]

@KimW , you can create a calculated column:

Fiscal month = 
IF( 'Date'[Month] > 9, 'Date'[Month] - 9, 'Date'[Month] + 3 )

Then sort your month name column with the newly created one:

[amitchandak]

@KimW , You can create a calendar that starts in April. I have a couple of blogs on how to do that

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1

[KimW]

Ive created a calendar that starts in Oct as the firat month as its the start to a financial year, however it still shows as april being the first month and ive used this calendar on all dashboards ive made however this is the first time i have this issue

[Anonymous · Accepted solution]

Hi @KimW ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Otherwise, you can refer the following blog to achieve it.

Sort a Column with a Custom Order in Power BI

1. Create a customized months sort order dimension table

Months	Order
October	1
November	2
December	3
January	4
Febuary	5
March	6
April	7
May	8
June	9
July	10
August	11
September	12

2. Combining the Sort Order Table with the Date Table

3. Sort by column [Order] field of sort order table

Best Regards