Need Help Sorting a Matrix by a hidden Measure

[yosefzav]

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 Rows, and on the Columns I have a column of Stages, which is 5 categorical values. As the Values I have a Count to give me the number of records in the table to give me the correct numbers. I need the matrix to sort descending by the Stage = "0 - Untouched Draft" to see who has the most in this stage.

There is no tooltip that I could add a field that only includes the Untouched Draft stages, so I'm at a loss for what to do. I have not been able to achieve this after working on it all day and have not found a working solution online, is there anyone who can help me out?

[yosefzav]

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 · Accepted solution]

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]

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)