Sort the fields in a matrix

[Anonymous]

Hi, 

I want to know if it is possible to easily sort the order in my matrix : 

Thanks 

Best Regards 

[Greg_Deckler]

Are you referring to the ordering of your columns or your rows? Rows you can sort by clicking on the column header or using the ellipses. If you are referring to your columns would have to understand more about your data and how that matrix is built. Are those individual columns or soemthing else? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

I refer to my columns order. My matrix is build like that : 

Assignment group = an individual column

Age group = a calculate column

Backlog = a measure 

The order that I want is : 01-02 days / 02-07 days / 07-14 days / > 14 days 

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your requirement, you could create a conditional index column in Query Editor and then sort the column age group by the conditional index column under modeling tab.

Here is the output.

For more details, please refer to my attachement.

Best Regards,

Cherry