Forum Discussion

PowerBINoob12's avatar
PowerBINoob12
Icon for Helper I rankHelper I
3 years ago
Solved

Sorting year and month on a graph

Hi,

 

I'm having immense trouble getting a graph to show the last 6 calendar months in order of the correct month.

Here is what i have on my Calendar table:


[Sort] is a combination of the year and month Jan2022 being 202201, feb 2022 being 202202 etc. I am then sorting it by this value ([sort]) on the table.

Then when I add [sort order] to a graph it has december in the incorrect position on both graphs:

Am I correct to think that if the table is sorted by [sort] the then [sort order] should sort in this order on the graphs?

 

Can anyone help me please?

additional pic that shows the value in dec2022 is less than Jan2023: 

 

Need Help
  • PowerBINoob12's avatar
    PowerBINoob12
    3 years ago

    I figured it out in the end.

     

    I needed to select the column I wanted to sort before I click "sort by column". I had just assumed clicing sort by column would do the whole table 🙂

4 Replies

    • PowerBINoob12's avatar
      PowerBINoob12
      Icon for Helper I rankHelper I
      3 years ago

      Hi Thanks for your reply and help.

      It was set to text but i've just changed it to whole number - but still the same issue on the graphs.

       

  • PowerBINoob12's avatar
    PowerBINoob12
    Icon for Helper I rankHelper I
    3 years ago

    I figured it out in the end.

     

    I needed to select the column I wanted to sort before I click "sort by column". I had just assumed clicing sort by column would do the whole table 🙂

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Hello.

    In the CALENDAR table you select the MONTH column LETTER

    Then, at the top, you choose SORT BY COLUMN and there you choose the column MONTH NRO

    And you're done

    You tell me xfa