cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diana66 Helper I
Helper I

Sort text and number values in matrix

Hello,

 

I have a matrix in which I have basically number values. I put an if condition, and if it applies, i have inserted a text(ex: "0 LY"). The problem is I want to sort by the values descending, and the text ones should be at the end. When I sort descending by the specific value, the ones with text are first, and I want them to be at the end. How can I do that?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Sort text and number values in matrix

Hi

extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.





Did I answer your question? Mark my post as a solution!

PLEASE follow these instructions to ask your questions!


Proud to be a Super User!




View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: Sort text and number values in matrix

Hi

extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.





Did I answer your question? Mark my post as a solution!

PLEASE follow these instructions to ask your questions!


Proud to be a Super User!




View solution in original post

diana66 Helper I
Helper I

Re: Sort text and number values in matrix

Hi @adetogni ,

 

Thank you!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors