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
Mizzi1234
New Member

is there an easy way to sort these column headers from matrix?

Mizzi1234_0-1728582292488.png

 

the weekday headers are out of order and need them to be from Monday - Sunday. any ideas?

2 ACCEPTED SOLUTIONS
MNedix
Super User
Super User

Heya,

In case of a visual you can either use a different column to sort your data or create a small sort/order table --> add it to the visual--> use it for sorting.

However, as far as I know, this is not applicable in case of a matrix. I suggest you check out this short video - link

 



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

View solution in original post

Hi,

I am not sure what you select in table view, but if you select table name, I think you cannot see Column tools ribon.

Please check the below screen shot, and please try select column name.

 

Jihwan_Kim_0-1728585289872.png

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @Mizzi1234 ,

 

How is the situation now? As @MNedix mentioned, you can create a sort table manually and create relationship between table. Here is a link about this method for your reference.Power BI Custom Sort Order In Bar Chart (devoworx.net)

 

 

Best regards,

Mengmeng Li

 

MNedix
Super User
Super User

Heya,

In case of a visual you can either use a different column to sort your data or create a small sort/order table --> add it to the visual--> use it for sorting.

However, as far as I know, this is not applicable in case of a matrix. I suggest you check out this short video - link

 



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,
Jihwan_Kim
Super User
Super User

Hi,

The link down below might help.

Link: Sort one column by another column in Power BI 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Hey,

 

So ive created a sort column in the dataset but I don't see the Column Tools ribbon in Powerbi.

Hi,

I am not sure what you select in table view, but if you select table name, I think you cannot see Column tools ribon.

Please check the below screen shot, and please try select column name.

 

Jihwan_Kim_0-1728585289872.png

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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