Forum Discussion
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
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
5 Replies
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-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1Ive 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
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
