Sort date field in Matrix column header descending

Hi ns29 ,

 

We can use the following steps to meet your requirement:

 

1. create a calculated table using following DAX:

 

ColumnHeader = 
ADDCOLUMNS (
    CROSSJOIN (
        DATATABLE (
            "ValueHeader", STRING,"ValueRank",INTEGER,
            {
                { "%_of_sample",2 },
                { "metric_value_1" ,1},
                { "metric_value_2",3 }
            }
        ),
        DISTINCT ( 'Table1'[metric_month] )
    ),
    "Rank", RANKX (
        DISTINCT ( 'Table1'[metric_month] ),
        [metric_month],
        ,
        DESC,
        DENSE
    )
)

 

2. Make metric_month column sort by Rank column, then make ValueHeader sort by Rank column.

 

3. create relationship between two tables based on the ColumnHeader column

 

4. create a measure used in the value field of matrix visual:

 

ValueInMatrix = SWITCH(SELECTEDVALUE('ColumnHeader'[ValueHeader]),"metric_value_1",SUM('Table1'[metric_value_1])&"","metric_value_2",SUM('Table1'[metric_value_2])&"","%_of_sample",FORMAT([%_of_sample],"Percent"))

 

 

Best regards,