Glitch in the Matrix Report on Date Sorting -- likely Bug

[charleshale]

I think there's a bug in the Matrix visual where sorting by date disappears in the sort options of the Column.   Check this out:.

1. If I show any date element in Column (such as Year or a date hierarchy), I have no option to sort by it.  Example below.   This matrix visual should show Year as a sort option.    Note - dax date table code provided at bottom.   

2. However, if I move that same field to Row in the Matrix visual, I can then sort by it.

So - the clear work around is to move the date to the Row, sort there, and then move it back to column.   But this seems pretty clearly to be a bug.

My Date Table DAX is below

DimDate = 
VAR MINYEAR =   2014  
VAR MAXYEAR =   2025
RETURN
ADDCOLUMNS (
    FILTER (
        CALENDAR(DATE(MINYEAR,1,1),DATE(MAXYEAR,12,31)),
        AND ( YEAR ( [DATE] ) >= MINYEAR, YEAR ( [DATE] ) <= MAXYEAR )
    ),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"HalfYear", YEAR([Date])&" H"&ROUNDUP(MONTH([Date])/6,0),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
-- as text "DayOfMonth", FORMAT ( [Date], "d" ),
"DayOfMonth", DAY ( [Date]), 
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"DayNumber", FORMAT ( [Date], "d" ),
"Quarter", FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ))

[Anonymous · Accepted solution]

Hi @charleshale ,

This is by design. If you want to sort the Column field, you can refer the following links to achieve it by using the feature Sort by column.

Solved: Sorting rows and columns in matrix visual - Microsoft Fabric Community

Solved: Re: Sorting Columns in Matrix Visual - Microsoft Fabric Community

Sort a Column with a Custom Order in Power BI

1. Create a customized sort order dimension table

Effet	Order
INDICE 1	1
OLD	2
ITM	3
CONCU	4
QTE	5
NEW	6
INDICE 2	7

2. Combining the Sort Order Table with 'Dimension' table

3. Sort by column

Best Regards