How do I get my dates in order

[walker8888]

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. 

[Anonymous · Accepted solution]

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!

[HotChilli]

This is usually caused by the month names being a column (text datatype) in the Fact table. Powerbi doesn't know it's a month representing a date.

--

Solutions: use a separate date table

or create a Month dimension table with a column to order the text types (using Sort by Column)

or use inbuilt powerbi date features (this will need a date in the Fact table)