I have placed the month name column (below) in a matrix however it does not order correctly.
Month = MONTH([Date])
How can I order the Month Name from January to December?
Go to Solution.
in the data view click on the month name column and thenunder the column tools tab click the sort bycolumn tab to sort by the month number column
View solution in original post
You can create a column on the date table like:
YearMonth = FORMAT(TABLE[DATE], "YYYYMM")
MonthName = FORMAT(TABLE[DATE], "MMMM")
and sort the MonthName by YearMonth
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.