How make Month Name in order

[Anonymous]

Hi Team.

Need your assistance on the below requirement.

i have connected direct to SQL and imported data after that while checking month name not in order wise see below.

Kinldy check and do the needful.

[lbendlin · Accepted solution]

Use a proper Calendar table that has the month number as a column. Then sort the month name by the month number.

[Anonymous · Accepted solution]

Hi, @Anonymous 

Thanks for the reply from Ibendlin, please allow me to provide another insight:

You can check if your data type is Text, if it is, it will be sorted alphabetically.

If it's of the Date type, Power BI will automatically sort you by month

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Use a proper Calendar table that has the month number as a column. Then sort the month name by the month number.