Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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
yes
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.