Forum Discussion

rjunai200's avatar
rjunai200
Helper I
10 years ago
Solved

Question about date sorting for chart

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.

Need Help

5 Replies

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

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

  • rjunai200's avatar
    rjunai200
    Helper I
    10 years ago
    No it just includes the month (January, Feb) since all the data is 2016
    • Sean's avatar
      Sean
      Community Champion
      10 years ago

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

       

      • rjunai200's avatar
        rjunai200
        Helper I
        10 years ago

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