cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmays86
Helper IV
Helper IV

Sorting "-" at the end of number list

Hello,

 

I'm using IFERROR to show error or null values as a "-" in my YTD Agreed Rlz field.  However, when I attempt to sort the field, the "-"'s sort ahead of the numbers.  It also does this even if I change the "-" to a zero.  Does anyone know how I could get the "-"s tort at the end after the actual % figures?

 

jmays86_0-1621017966371.png

 

Thanks in advance!!!

 

Jordan

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @jmays86,

I'd like to suggest you take a look at the following blog to know how to create a custom table to apply custom sorting orders on specific fields.

Custom Sorting in Power BI 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks, but this custom sorting method will not resolve my issue as I'm trying to sort by the the #'s in the Agreed Rlz measure and not by another field.  I would simply like anything that's not a number (the IFERROR, "-"piece) to sort after all the numbers.  Right now, the "-" defaults to sort ahead of the numbers.

-Jordan

HI @jmays86,

I check the formula and find it seem to convert the result to text type.

For text values, in sorted based on ASCII code(notice: special symbols 'char number' are less than letter characters) so the specific characters are sorting above general values.

You can change the sorting order from ASC to DESC and these '-' records will list on the bottom side.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors