Forum Discussion
Kalachuchi
Helper III
5 years agoSort row header of matrix
Hey guys how do we sort row header of matrix decendingly?
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
1 Reply
- az38
Community Champion
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