Skip to main content
cancel
Showing results for 
Search instead 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

Reply
RoundedWheels
Microsoft Employee
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?

 

Thanks in advance!

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@RoundedWheels 

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

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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Hi, @RoundedWheels 

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
)

 

Picture2.png

 

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

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.


Click here and Go to My LinkedIn Page


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
Super User
Super User

@RoundedWheels 

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

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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks @Fowmy , very clear!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors