Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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, i...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
JosefPrakljacic
Solution Sage
7 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      6 years ago

      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

       

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      6 years ago

      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