按数字顺序排列带有文本和数字的列

Question

下面是两列，代表62分钟的时间段，细分为一分钟一分钟的片段。我有问题，使段名列的顺序是: ES-L FTD 1，ES-L FTD 2，ES-L FTD 3.我需要他们是为了产生一分钟一分钟的图表，显示输出数据。

如能提供任何帮助，将不胜感激。

Segment Name    Time       Output Data
ES-L FTD 1       1:00
ES-L FTD 10      1:00
ES-L FTD 11      1:00
ES-L FTD 12      1:00
ES-L FTD 13      1:00
ES-L FTD 14      1:00
ES-L FTD 15      1:00
ES-L FTD 16      1:00
ES-L FTD 17      1:00
ES-L FTD 18      1:00
ES-L FTD 19      1:00
ES-L FTD 2       1:00
ES-L FTD 20      1:00
ES-L FTD 21      1:00
ES-L FTD 22      1:00
ES-L FTD 23      1:00
ES-L FTD 24      1:00
ES-L FTD 25      1:00
ES-L FTD 26      1:00
ES-L FTD 27      1:00
ES-L FTD 28      1:00
ES-L FTD 29      1:00
ES-L FTD 3       1:00
ES-L FTD 30      1:00
ES-L FTD 31      1:00
ES-L FTD 32      1:00
ES-L FTD 33      1:00
ES-L FTD 34      1:00
ES-L FTD 35      1:00
ES-L FTD 36      1:00
ES-L FTD 37      1:00
ES-L FTD 38      1:00
ES-L FTD 39      1:00
ES-L FTD 4       1:00
ES-L FTD 40      1:00
ES-L FTD 41      1:00
ES-L FTD 42      1:00
ES-L FTD 43      1:00
ES-L FTD 44      1:00
ES-L FTD 45      1:00
ES-L FTD 46      1:00
ES-L FTD 47      1:00
ES-L FTD 48      1:00
ES-L FTD 49      1:00
ES-L FTD 5       1:00
ES-L FTD 50      1:00
ES-L FTD 51      1:00
ES-L FTD 52      1:00
ES-L FTD 53      1:00
ES-L FTD 54      1:00
ES-L FTD 55      1:00
ES-L FTD 56      1:00
ES-L FTD 57      1:00
ES-L FTD 58      1:00
ES-L FTD 59      1:00
ES-L FTD 6       1:00
ES-L FTD 60      1:00
ES-L FTD 61      1:00
ES-L FTD 62      1:00
ES-L FTD 7       1:00
ES-L FTD 8       1:00
ES-L FTD 9       1:00

Answer 1

我建议为您的段名设置索引(所需的顺序)。

根据官方说法，您可以在这里找到微软的解决方案：https://learn.microsoft.com/en-us/power-bi/desktop-sort-by-column

但是，我认为以下内容更有帮助：https://community.powerbi.com/t5/Desktop/SORT-Order/td-p/370139

谢谢!威廉