In Pivot Sort order - 1M is considered less than 100K

[manoc]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• [Y] I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.22.1

Expected results

In Pivot when we sort ascending by any measure, it supposed to show 100K above and 1M below.

Actual results

It considered 1.07M is less than 100K

Steps to reproduce

Open Births dashboard -> navigate to last Pivot chart -> Sort all filed Ascendingly

[zancos]

Same here. When sorting, 1.02k is smaller that 2.00 if using .3s number format.
We are using version | "0.25.6"

[tristix]

This is still an issue.

When sorting, 900 is > 1.2k apparently.

We migrated from v0.20 -> v0.26 this morning and it was noticeable straight away

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[rumbin]

Please do not close this bug unless ist has been fixed

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[mistercrunch]

It's been fixed:

[tristix]

Amazing thank you!