Report: How to change the rows alphabetical order display

[ANTONIO1981]

HI I uploaded the following data


i would like to have LY in the first row and TY in the last row. But power bi displays the report in alphabetical order

how can i solve it?. thanks

Column1	Column2
Comm	-6.2
FCPS	-6.4
LY	159.9
OH	-8.3
Other inc	1.5
RPW	9.5
Sites	0
TY	414.4
VCPW	2.2
Vol other	172.4
Vol wds	90

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Matt Allington]

Load a third column of integers with the sort order you want. Then in the modelling tab you can set "sort by column" to change the sort order of the alpha column to use the integer column instead

 

[ANTONIO1981]

many thanks!!!