Forum Discussion
Solved
Sort By Month
Power BI. My report comes with month name, not month number column. I add monthnumber column but when creating my chart, it sorts month alphabetically. I try to sort by monthnumber column but does not do so. Please help
In Model view. you can go and add sort by column for month name.
The idle sort for the month is
month sort = format(date,"YYYYMM")
2 Replies
- amitchandak
Super User
In Model view. you can go and add sort by column for month name.
The idle sort for the month is
month sort = format(date,"YYYYMM") 
v-joesh-msftSolution Sage
Hi FNFN ,
You can refer to this article: Sort By Month Names In Power BI
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.