Forum Discussion

yosefzav's avatar
yosefzav
New Member
2 years ago
Solved

Need Help Sorting a Matrix by a hidden Measure

Hey there, I feel like I'm going crazy trying to figure out this very simple functionality of what I would expect Power BI should be able to handle. I have a matrix that has a list of names on the R...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi yosefzav,

    Perhaps you can try to create a sorting table to link the current table. Then you can use the new table fields on the matrix column field to apply the custom sorting orders.

    Custom Sorting in Power BI  
    Regards,

    Xiaoxin Sheng

yosefzav's avatar
yosefzav
New Member
2 years ago

Hey adudani thanks for reaching out. Unfortunately the sort doesn't appear for each of the categories, only for the totals or the list of names in the rows (unless that is a feature that has been added in a newer version of power bi). Also I just tried adding the measure into the rows as the last hierarchy level in the rows, but unfortunately it still doesn't allow me the option to sort by that field, just by the main row and column fields.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yosefzav,

Perhaps you can try to create a sorting table to link the current table. Then you can use the new table fields on the matrix column field to apply the custom sorting orders.

Custom Sorting in Power BI  
Regards,

Xiaoxin Sheng