Forum Discussion

PatP's avatar
PatP
Frequent Visitor
8 years ago
Solved

Months in wrong order

Hi!   I’m trying to order months in the right order in a table and in a graph. From what I understand, I have to order by month number in my “Date” Table, but it doesn’t work. What I am doing wrong...
Need Help
  • rema's avatar
    rema
    8 years ago

    Hi PatP

    I think your monthnumber column is text field instead of number. You can check once.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

In that Table, ensure that you keep your active cell in the Month column and then go to Sort by Column.

PatP's avatar
PatP
Frequent Visitor
8 years ago
Hi,

Thanks for your reply. This is what I did that you can see in my last screenshot I think. Is that what you mean or something else that I'm missing?
  • rema's avatar
    rema
    Advocate I
    8 years ago

    Hi PatP

    I think your monthnumber column is text field instead of number. You can check once.

    • PatP's avatar
      PatP
      Frequent Visitor
      8 years ago

      rema you are right! But even if I change if as a number, it doesn't work! I should be missing something :/

       

      • PatP's avatar
        PatP
        Frequent Visitor
        8 years ago

        I finally got it to work! I wasn't sorting the right column. Beginner mistake. Thanks!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Share the link from where i can download your PBI file.