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

adudani's avatar
adudani
Memorable Member
2 years ago

hi yosefzav ,
Maybe try using the sort functionality available by hovering over the column  of the matrix and right clicking near the arrow shown below?

 

 

if not , create a measure with calculate and in the filter context count those values having the relevant stage. using that in the last row of the matrix could help sorting ( note: would required not expanding into the last level of hierarchy)