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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
160475
Helper I
Helper I

sorting columns

dears,

good day!! 

 

in my raw data i have this 

160475_0-1672217715376.png

where i have column batch from 1 to 48 and batch sort is the index sort 

when i apply this to power bi it give me this sort 

160475_1-1672217839906.png

can anyone help me ? 

 

thank you!! 

1 ACCEPTED SOLUTION
HiraNegi
Resolver II
Resolver II

Check the datatype of your 'batch sort' field. It should be Number.

Usually if the data type of sort field is Text, then it sorts as you have shown in the screenshot

View solution in original post

5 REPLIES 5
160475
Helper I
Helper I

thank you all i have fixed the issue 

HiraNegi
Resolver II
Resolver II

Check the datatype of your 'batch sort' field. It should be Number.

Usually if the data type of sort field is Text, then it sorts as you have shown in the screenshot

ghoshabhijeet
Solution Supplier
Solution Supplier

@160475  Thanks for sharing your query. For sorting the data correctly follow the steps below:

1. Goto the data view

2. Change the data type of BatchSort to Number

3. Select the column (i.e. BATCH) and then click on the dropdown "Sort by column"

4. Select BatchSort column from the drop down

5. Now, goto the report view and the data should be sorted as expected in the table visual

ghoshabhijeet_1-1672218711837.png

 

NOTE: If the data is still not sorted, then you need to perform additional step, on the table visual select the Sort By as shown in the below snapshot.

ghoshabhijeet_0-1672218689531.png

 

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍

 

FreemanZ
Super User
Super User

HI @160475 

 

It seems 1, 11, 2 are sorted as Text, please ensure the data type of the column is number. 

amitchandak
Super User
Super User

@160475 , seem like data type is test, make it number

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.