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.

PatP's avatar
PatP
Frequent Visitor
8 years ago

This is exactly what I did, but the order in the table and chart remain the same. What else could explain this?

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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
      Icon for Advocate I rankAdvocate 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 :/

         

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

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