Reordering months

[Anonymous]

By default charts show months in the x-axis starting in January and ending in December. However, I'd like the x-axis to follow the same order of our fiscal year, which starts in July and ends in June. How can I get this?

Thanks in advance!

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

I suggest creating a new column for the purpose of "sort by fiscal year".

In your case, please write a formula something like the below for creating a new column for a sorting purpose.

Month Name Sort FY CC =
SWITCH (
TRUE (),
Dates[Month Name Sort CC] IN { 7, 8, 9, 10, 11, 12 }, Dates[Month Name Sort CC] - 6,
Dates[Month Name Sort CC] + 6
)

https://www.dropbox.com/s/eiw7gf02cx8p92y/roundedwheels.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Thanks a lot @Jihwan_Kim .

In understand how you create that column with a number in the right order (i.e. July=1, August=2, etc.). But, how do you make the Chart use that order to display the month names in the X-axis? Is there any property in the Chart fields that allow you to decide whether using "Month Name Sort CC" or "Month Named Sort FY CC"?

[Fowmy · Accepted solution]

@Anonymous 

Create a column in your calendar table to sort the months/year in Fiscal month order as shown in the video:

https://www.youtube.com/watch?v=0peKz7XjEdw

[Anonymous]

Thanks @Fowmy , very clear!