Forum Discussion

walker8888's avatar
walker8888
Icon for Helper II rankHelper II
2 years ago
Solved

How do I get my dates in order

Hello I created a matrix visual and have added my Month datat to columns. However my months show up in alphabetical order instead of monthly order. Anyone knows how this can be fixed? Thanks.    ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi walker8888 ,

     

    Thanks for the reply from HotChilli  .

     

    It's easy, just create an Index column in Power Query.

     

    After clicking Close and Apply to return to Power BI Desktop, go to the Data view, select the Date column (which may be the Month column in your data), and then select Sort by Index column in the toolbar.

     

    The page effect is as follows:

     

    If you have other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi walker8888 ,

 

Thanks for the reply from HotChilli  .

 

It's easy, just create an Index column in Power Query.

 

After clicking Close and Apply to return to Power BI Desktop, go to the Data view, select the Date column (which may be the Month column in your data), and then select Sort by Index column in the toolbar.

 

The page effect is as follows:

 

If you have other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!