Question about date sorting for chart

[rjunai200]

Hi i am new to power bi and am figuring out how to sort the Month Date as right now its showing april, jan, feb  ect. i tried a few things to convert the Text range to date as i export data from excel  but it did not help

my data is setup as following:

A   January 56566

B   January 26548

C   January 45455

A   February 51150 

B...February 

c..February 

I searched and found a few formus that discuss this issue. but they had a more complex date fomat so it was harder to follow.

[rjunai200]

No it just includes the month (January, Feb) since all the data is 2016

[Sean · Accepted solution]

@rjunai200 follow the picture... let me know if it works...

[rjunai200]

thank you that did work! is there any way i can format it in excel before i upload the file into Power BI

[Sean]

Should work the same way!

[Sean]

do you have a Date column that includes the full date? or day and year columns as well? or a calendar table?