Forum Discussion
Custom X Axis in Bar Graph
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
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!
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