Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hb0135
Helper III
Helper III

How to get serial No in table for Power BI

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 

 

 

hb0135_0-1714638836004.png

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

hb0135_1-1714638959549.png

 

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
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hi,
Thanks for the help it worked 
Reagrds

Atharva 

PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hello,

I tried as you said but this happening

hb0135_0-1714644213232.png

Regards,
Atharva 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors