Forum Discussion
Power BI
Hey Mates .... I have been trying to build a report where I'm stucked with a issue like month names are not in order ,even after sorting and tried many ways to sort ,by transforming data,adding new ...
You can follow below steps:
1)you can add a new column in Power Query Editor or using DAX to represent the monthnumber..
MonthNumber =
SWITCH(
[Month],
"Jan'23", 1,
"Feb'23", 2,
"Mar'23", 3,
"Apr'23", 4,
"May'23", 5,
"Jun'23", 6,
"Jul'23", 7,
"Aug'23", 8,
"Sep'23", 9,
"Oct'23", 10,
"Nov'23", 11,
"Dec'23", 12,
BLANK()
)
- Sort the data by the MonthNumber column.