Forum Discussion
Dynamic sorting for matrix column headers
Hi jsangerman ,
Columns cannot be custom sorted by using a measure - a physical column, calculated or created in PQ is necessary. Also, a unique item in a column cannot be sorted more than once (eg Milestone 1 is either in the first or second order but not both). As a workaround, you can create another column that references the original and append an invisible string to it. The count of which depends on the rank of the column value you were going to initially use for sorting. Please see attached sample pbix.
Hi jsangerman ,
Columns cannot be custom sorted by using a measure - a physical column, calculated or created in PQ is necessary. Also, a unique item in a column cannot be sorted more than once (eg Milestone 1 is either in the first or second order but not both). As a workaround, you can create another column that references the original and append an invisible string to it. The count of which depends on the rank of the column value you were going to initially use for sorting. Please see attached sample pbix.
Yes! It occurred to me this would work, and then I saw your post confirming it. Thank you for the example, as well.