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.
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?
Solved! Go to Solution.
or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"
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
@BJE - Use a separate colum with numeric sort values. Use the Sort By feature to sort your text column by your numeric column.
Thanks. Have tried that - not changing my visual.
if it is not acceptable for aesthetic reasons, try somethonk like this
or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"
Thanks - this worked for me
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 |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |