Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

I have the following matrix

shashank102_0-1649139526590.png 

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

shashank102_1-1649139741247.png

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

4 REPLIES 4
Anonymous
Not applicable

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
Not applicable

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

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

yes

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.