Sort row header of matrix

[Kalachuchi]

Hey guys how do we sort row header of matrix decendingly? 

[az38 · Accepted solution]

Hi @Kalachuchi 

for this goal there is a solution based on Daniil Maslyuk article https://xxlbi.com/blog/built-in-column-sort-order-power-bi/

Create new column:

Date Desc = 
CONCATENATE(
 REPT(
  UNICHAR(8203),
  RANKX('Calendar', 'Calendar'[Date], , ASC)
 ),
 FORMAT('Calendar'[Date], "YYYY-MM-DD")
)

 and use this column as a Column in matrix