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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
KPerrySHI
Frequent Visitor

Sorting by Column Header in Matrix?

Hey Folks,

 

Hopefully a simple question, but is it possible for users to sort individual columns in a matrix? In this use case we would like to sort by the most orders per row for February, but we are only able to sort by the all-up total for the months in time period.  Clicking the column only selects it and does not offer sorting options.

 

OrdersByMonth.png

1 ACCEPTED SOLUTION

Hi @KPerrySHI ,

You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @KPerrySHI ,

Based on my research, you may refer to below link to custom sort matrix header:

https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sadly, we connect to an Analysis Service which limits our abilities to manipulate the source data, and we can't access the Sort by Column options in the ribbon.

 

Capture.PNG

 

Was hoping there would be additional options in the visual, but I appreciate the help.

Hi @KPerrySHI ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @KPerrySHI ,

You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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