How to get serial No in table for Power BI

[hb0135]

Hello,

I have put like this SR No in excel file but in power BI table visual the Sr No are not coming in serial way they are coming in random way i have tried to sort column by Index No but below meassage occurs 

And in power BI the table is looking  like this for Sr NO

And my Sr No are like this in excel file 

Sr. No.
1
2
3
4
4.1
4.2
5
6
7
8
9
10
11
12
12.1
12.2
13
14
14.1
14.2
14.3
14.4
14.5
15
15.1
15.2
15.3
16
17
18
19
19.1
19.2

[PhilipTreacy · Accepted solution]

Hi @hb0135 

I'd say that column is stored as text rather than numeric data.  Check in Power Query that the column is numeric.  The column should have an icon in the top left : either 1.2 or 123, rather than ABC123.

Phil

[hb0135]

Hi,
Thanks for the help it worked 
Reagrds

Atharva 

[PhilipTreacy]

Hi @hb0135 

In that image it looks like the numbers are being sorted in descending order.  Below the column name Sr. No. there's a triangle pointing down.

Click on that and it should sort the column as you expect, in ascending order - providing that the column is a numeric type and not text.

Phil

[hb0135]

Hello,

I tried as you said but this happening

Regards,
Atharva