Months in visualizations needs to be sorted

Hello Anonymous,

Create a calculated column as below:
MonthSortNumber = VALUE(YEAR(Date[Date]&FORMAT(Date[Date],"MM"))

Then click on [Month] column > Go to Modeling > Sort by Column > MonthSortNumber.

Your [Month] column will be sorted.

Hope this helps.

HI Anonymous ,

Please take a look at the following blog to create a sorting table to apply custom sort order based on 'sort by column' feature.

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng