Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rjunai200
Helper I
Helper I

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.

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

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

Sort by Month Name.png

 

View solution in original post

5 REPLIES 5
rjunai200
Helper I
Helper I

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

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

Sort by Month Name.png

 

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

Sean
Community Champion
Community Champion

Should work the same way!

Sort by Month Name2.png

Sean
Community Champion
Community Champion

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors