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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

5 REPLIES 5
v-mengmli-msft
Community Support
Community Support

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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