Reply
KimW
New Member
Partially syndicated - Outbound

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 

1 ACCEPTED SOLUTION

Syndicated - Outbound

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
ERD
Community Champion
Community Champion

Syndicated - Outbound

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

ERD_0-1669797148416.png

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!

ERD
Community Champion
Community Champion

Syndicated - Outbound

@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:

ERD_0-1669796651499.png

 

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!

amitchandak
Super User
Super User

Syndicated - Outbound

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

Syndicated - Outbound

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)