Forum Discussion
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.
HTH,
Michele