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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Anonymous
Not applicable

Sorting January after December

I have a line chart with the January, November and December at the bottom  of the chart. January is for 2018 so it needs to be last. How do I get the chart to put the months in that order? The year is not in the character date but I do have it in another field.

 

Thanks, Mark

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee


@Anonymous wrote:

I have a line chart with the January, November and December at the bottom  of the chart. January is for 2018 so it needs to be last. How do I get the chart to put the months in that order? The year is not in the character date but I do have it in another field.

 

Thanks, Mark


@Anonymous

The unexpected sorting order may be caused by your data type, what is the type of the axis column? If date type, there shall be no problem. As to text type, you can reference Sorting by Month Names in Power BI

Capture.PNG

View solution in original post

1 REPLY 1
Eric_Zhang
Microsoft Employee
Microsoft Employee


@Anonymous wrote:

I have a line chart with the January, November and December at the bottom  of the chart. January is for 2018 so it needs to be last. How do I get the chart to put the months in that order? The year is not in the character date but I do have it in another field.

 

Thanks, Mark


@Anonymous

The unexpected sorting order may be caused by your data type, what is the type of the axis column? If date type, there shall be no problem. As to text type, you can reference Sorting by Month Names in Power BI

Capture.PNG

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.