Forum Discussion

Continued Contributor

7 years ago

Solved

How to sort total in a matrix with multiple row groups, where drilldown is at lowest level?

Hi all I have set the matrix up as below: On the drilldown buttons, I have pressed the right hand button labelled 'At the lowest level of data'. As you can see, the total sort order...

Need Help

Anonymous
7 years ago
HI ansa_naz,

Nope, I don't think you can direct sort by sub-total level, power bi will drill to detail records and sort by them.

Current power bi support to use one of axis or value field as sort order, you can also refer to following link to use 'sort by column' to define default sort order or records.

Custom Sorting in Power BI

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

7 years ago

HI ansa_naz,

Nope, I don't think you can direct sort by sub-total level, power bi will drill to detail records and sort by them.

Current power bi support to use one of axis or value field as sort order, you can also refer to following link to use 'sort by column' to define default sort order or records.

Custom Sorting in Power BI

Regards,

Xiaoxin Sheng