Forum Discussion
Custom X Axis in Bar Graph
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?
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
6 Replies
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,
JosefHello 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