How to get data in order by id After Adding id (int) and name(string) in powerbi

[LalithaDevi]

Hi,

Here I want to append id and name columns as single column and want the result in descending order as per id

id      name
1       john
2       peter
7       spider
10     Arvind
100    beth
44      jack
76      Roy
22      Raj

but when I append these id and name by using - , i got the result like this when i select descending

76-Roy
7-spider
44-jack
22-Raj
2-peter
100-beth
10-Arvind

but we want the data like below

100-beth
76-Roy
44-jack
22-Raj
10-Arvind
7-spider
2-peter

As per my understanding it is taking values as string , so we are getting data like this , Could you please suggest how can i get data in order by id value

[SpartaBI · Accepted solution]

Hi @LalithaDevi,

You should use the "sort by column" feature- Link.
This means having both the concatenated column and the numbers column in your model.