Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |