Skip to main content
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.

Not applicable

Sorting by Month as Text (Jan Feb Mar etc)


I notice in the Power BI Service we still can't sort a chart by another field.


This is annoying.  A workaround I found is to add a calculated column with a period as prefix to the month. 





Go to Power BI Desktop

If you don't already have a month number column, add one.

Select the column containing the month names

Select Modeling tab > Sort By Column and from dropdown select the column that has the month numbers.

Now when you publish to PBI Service, sorting will work correctly.







Not applicable

Quick update on this.  I found a column property setting in Analysis Services tabular enables me to specify a sort column.


With Power BI Desktop the charts automatically sorted using this property.  


I'm just waiting for model changes to be pushed to the service to see if the online chart sorts.



You should be able to use another column to sort by.  It is hidden in the column properties. You select sort by, then choose another column. I have, in the past, used the month number column to sort my month name column.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

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


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
Top Kudoed Authors