How to sort 2 columns with different sort keys in matrix power BI

[Anonymous]

I have the following matrix

 

this is imported from SSMS and table is as given below,here values are sorted by sortorder and dimensions are sorted by dimension sort.

I want to sort both of them in my matrix in power bi which is a live connection in SSAS TABULAR CUBE where dimensions order should be like # of attorneys,location,practice area,class year

what i tried was to add ID-sort column and use that but its not working out.

[v-jayw-msft]

Hi @Anonymous ,

As far as I know, this feature is supported in Table visual but not in Martix visual.

In a Table visual you could shift+left click the column header to sort the visual by multiple column.

You could submit this as an idea.

https://ideas.powerbi.com/ideas/ 

Best Regards,

Jay

[Anonymous]

• @amitchandak yes I have defined sort columns for both in SSas 

[amitchandak]

@Anonymous , Have defined sort column in SSAS for both these ?

[Anonymous]

yes