Sorting "-" at the end of number list

[Anonymous]

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?

Thanks in advance!!!

Jordan

[Anonymous]

HI @Anonymous,

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

[Anonymous]

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

[Anonymous]

HI @Anonymous,

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