Custom X Axis in Bar Graph

[Anonymous]

I'm trying to sort the look of this bar graph -- it is intended to be a 5 Month Rolling look at a pipeline. 4 months are obviously the remainder of 2019 (Sept-Dec), but when I include January 2020, it auto sorts chronologically with the months and puts January in front as the first month. I need January to show up as the last month on the view since it's in 2020 and the rest of the months are in 2019. Anyone know how to somehow include the year in the sorting of the x-axis items and put January (and when next month hits, February 2020, and so forth) in front?

[JosefPrakljacic]

Your answer lies in the following youtube video.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

[Anonymous]

Hello, thanks for linking that video, however, this still doesn't troubleshoot the issue since I have 4 of the months in 2019, and one month in 2020. So I would need it to be in order as: September, October, November, December, January

[JosefPrakljacic]

Hello @Anonymous,

Im sorry for my missunderstanding.

Here you can see that I could get the work done 

What did I do? I ordered the MonthLong columny by a YearMonthNo Column (2019XX -> Datatype WholeNumber)

Here is my example file

If this post was helpful may I ask you to mark it as solution and give it some kudos?

BR,
Josef

[Anonymous]

Hi Josef, 

Thanks so much for your help, & and I apologize for still misunderstanding on my end, as I'm trying to sort the graph the way I would like without having to add more columns to the data. I've attached two screenshots of both the data it's pulling from, and the fields which the graph is applying to from the data. Any further help is much appreciated. Thanks!

https://ibb.co/ypyrNxM
https://ibb.co/0GpnFjS

[v-piga-msft]

Hi @Anonymous ,

Have you solved the problem with the suggestion of JosefPrakljacic ?

If you have solved the problem, please always always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share the data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[JosefPrakljacic · Accepted solution]

I don't get it.

If you only need 5 months, then you can change the parameters of the Date table in my example and enter the necessary range.

You should have a Date table and link it to your table. (Why? Here is an explanation)

If you don't want a DateTable for whatever reason you have to add another column to your existing table -> 

YearMonthNo = FORMAT ( [Close Date], "YYYYMM" )

You then classify this column as a number and you sort your monthnames by this column.

That should meet your communicated expectations....

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef