Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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 @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |