Sorting a visual using text-based ranges

[BJE]

I have a table that I has a column recording the FTE for each company in the list. I have created an additional column that has created FTE ranges, i.e.:

0-4

5-9

10-24

25-49

50-99

100-149

150-199

200+

When I use the FTE Ranges as the axis on my visual, I can't sort in this order. If I try and sort by FTE Range it orders them as follows:

0-4

100-149

10-24

150-199

200+

25-49

50-99

5-9

Any ideas?

[ziying35]

@BJE 

let
    Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("i65WcgtxVbJSMtA1UarVgfEMDQx0DU0sUUR0jVBUmAJVWCKrMDIw0EbmmuqiGABUj6LcVBfIiwUA",BinaryEncoding.Base64),Compression.Deflate))),
    sort = Table.Sort(Source, {each Number.From(Text.SplitAny([FTE],"-+"){0}), Order.Ascending})
in
    sort

If my code solves your problem, mark it as a solution

[Greg_Deckler]

@BJE - Use a separate colum with numeric sort values. Use the Sort By feature to sort your text column by your numeric column.

[BJE]

Thanks. Have tried that - not changing my visual.

[Anonymous]

if it is not acceptable for aesthetic reasons, try somethonk like this

[Anonymous · Accepted solution]

or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"

[BJE]

Thanks - this worked for me