Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Months not sorting in a graph

Hi All

I have a direct query and it doesnt allow ORDER BY . Inmy graph i have months randomly places and not in an order , is there a way to fix this please see the screen shot.

 

Need Help

10 Replies

  • Cmcmahan's avatar
    Cmcmahan
    Resident Rockstar
    7 years ago

    What field are you using for month on your X axis? 

     

    If it's some sort of calendar/date dimension, select that field in the Fields pane, and in the Modeling ribbon click Sort by Column to sort it by the Month Number.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks its a field called MOnth Name from the date dimension , i have no clue what what you asked me to i cannot find a ribbon can you please send me a screen shot?

      Thanks