Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
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?
Solved! 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
Actually, I figured out how but I'm getting this error message:
it should be just the month number not the monthyear
Thank you that worked!
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
@HenryJS ,
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
I followed you until the last step. How do I sort MonthName by YearMonth in a matrix table?
once you do the sort in the table view it will work in all visuals including the matrix, BTW you can sort it by a column that has just the month number it dosn't have to be a yearmonth column
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |