Forum Discussion

mrothschild's avatar
mrothschild
Continued Contributor
6 years ago
Solved

Cluster Column Chart - sorting by dates

In the screenshot below, you will see that the x-axis is not sorting correctly.  When I drill up in the hierarchy, the quarters and years sort correctly.  Even if I add "Date" to the Axis hierarchy the results are the same.  

 

Any thoughts?

 

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    mrothschild you have to month sort column in your model and sort you month wiht this month sort on modelling tab.

     

    So add another column called Month Number which will be 1 for Jan, 2 for Feb and so on.

     

    Selected Month column, go to modelling tab under sort by column, in drop down, select month number column. Basically you are telling model that you want to sort Month column by Month Number otherwise your Month column is sorted alphabetically which doesn't make sense in case of Month

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    mrothschild you have to month sort column in your model and sort you month wiht this month sort on modelling tab.

     

    So add another column called Month Number which will be 1 for Jan, 2 for Feb and so on.

     

    Selected Month column, go to modelling tab under sort by column, in drop down, select month number column. Basically you are telling model that you want to sort Month column by Month Number otherwise your Month column is sorted alphabetically which doesn't make sense in case of Month