Forum Discussion
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!
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
4 Replies
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=0peKz7XjEdwThanks Fowmy , very clear!
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
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"?
