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.

Ritesh_Air's avatar
Ritesh_Air
Post Patron
5 years ago

Hello,

 

I am having the same issue. I tried everything. My month name is getting sorted by Month Number (which is a whole number). I am using a shared dataset. If I put the visual in shared dataset to test, it gives correct value. But in report itself which is referencing to the Shared data set gives the wrong sort order. Not sure why it's happening. It was working fine earlier.

 

In Report:

 

 

 

 

In Shared Dataset: Correct sort order