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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Zack92
Helper III
Helper III

Sort by Value on Power Bi Matrix table

Hello, 

 

I am trying to sort values in the following order. Which is Early on top, Mid in the middle, and Late on the bottom. Can anybody please guide me on how to do this? Regular sort does not work. 

 

Thank you 

1 ACCEPTED SOLUTION
Arunmatt1
Frequent Visitor

Screenshot 2024-01-31 160422.pngHello Zach,

You can sort a column by going into Table view, clicking on the column, and then selecting 'Sort Column by.'

 

 If you don't have another sort column, I would create a conditional column using Power Query. For example, if I need to sort colors like blue, green, red, I would create a conditional column stating 1 = blue, 2 = green, 3 = red. Then, I would go to the data view and sort the color column using the conditional column I created.

I hope this helps.

View solution in original post

1 REPLY 1
Arunmatt1
Frequent Visitor

Screenshot 2024-01-31 160422.pngHello Zach,

You can sort a column by going into Table view, clicking on the column, and then selecting 'Sort Column by.'

 

 If you don't have another sort column, I would create a conditional column using Power Query. For example, if I need to sort colors like blue, green, red, I would create a conditional column stating 1 = blue, 2 = green, 3 = red. Then, I would go to the data view and sort the color column using the conditional column I created.

I hope this helps.

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.