- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Date Format
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-16-2024 01:10 AM | |||
11-07-2024 01:53 AM | |||
06-27-2024 07:15 AM | |||
06-02-2024 04:30 AM | |||
07-09-2021 06:40 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |