cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Microsoft Employee

## Reordering months

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?

1 ACCEPTED SOLUTION
Super User

@RoundedWheels

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
4 REPLIES 4
Super User

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
)

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.

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

Microsoft Employee

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"?

Super User

@RoundedWheels

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Microsoft Employee

Thanks @Fowmy , very clear!