Month name in chart not in order

[Beiffon]

HI,

I am having issues getting the below chart to show the months in order. Any ideas?

[pfarahani]

I am having the same problem, I have a Line Chart, for 2017. And the order is going March 2017, August, 2017, January 2017, October 2017 .....................In my Axis Field I have MonthName. Any ideas how to fix in the right order?

[Hardik]

I hope that the months data has years attached to it  and if not,year for a particular month can be added to the data so that powerbi sorts them in a proper order. 

[Anonymous]

Check the data type of month, make sure it is date or date/time. Then Power BI will sort the months accordingly

[Beiffon]

HI, I get the following error when trying to change

[mmace1]

Is your underlying data, really just the month names themselves then?   i.e. 'January', 'February', etc? 

If so...do you have a way to add another column to your 'month name' data?  Maybe editing the excel or csv file it comes from?  I'm thinking you could add month numbers manually, then tell Power BI to sort by them. 

[Anonymous]

What's your orignial data type of months? Is it only have month information without any year and day values? If this is the case, Power BI would not allow you to covert it to date type since it is not actually a value date value. 

One solution I have is to replace your January to 1/1/2018, means to add year and day values to month for creating a real date value. 

You can go to Query Editor to duplicate the month column and then use Replace feature to do it. After you create the real date values, Power BI will be able to sort the month correctly.