Forum Discussion
Sorting characters after numbers
I have a measure that returns either a number or a "-" character. I have put this measure in a table visual and sorted it in descending order. It shows at the top the rows with measure="-" and then a...
v-gizhi-msft I'm not sure what you did. But, did you replace dashes with zeros and then format zero to be a dash? I don't think that will work when my measure takes negative values. I would love to have a table sorted natively like this:
| 10 |
| 4 |
| 0 |
| -12 |
| -19435 |
| - |
| - |
I guess it is not possible to customize the default order.
Hi,
I think there is no other easier solution expect my first reply.
Best Regards,
Giotto Zhi