can we remove default sorting option in data table power bi

[Ayappan]

Hi Team ,

    I have a table like below. This is how it comes in Transform data..

P1	Copper
P1	Arrow
P1	Zinc
	Copper
P2	Arrow
P2	Zinc
P3	Copper
P3	Arrow

But when i select this column in DataTable it is sorting 

P1	Arrow
P1	Copper
P1	Zinc
P2	Arrow
P2	Copper
P2	Zinc
P3	Arrow
P3	Copper

I  Wanted in same order ...How to do it ..please guide me .

Thanks 

[rachelgomez1234]

Use columnDefs option to remove sorting from a column. Pass column index in targets within [] (Indexing starting from 0) and set orderable to false . In the example, I removed sorting from email and salary column.

Regards,

Rachel Gomez

[FrankAshby]

As @KeyurPatel14 suggested an index column would probably solve this. Don't forget to set the sort order by the index column, otherwise wasting time/effort 😅

Basic, but does the job.

[KeyurPatel14 · Accepted solution]

Hi @Ayappan ,
I have implemented the same scenario just like yours.
I can not say tha this is the ideal way to do this but if you can not find anyway then this might help you.

1. I added one index column in Power Query and gave the name as . as shown in below image.
For adding index column, Go to Power Query --> Add Column Tab --> General Section --> Index Column.

2.Close and apply Power Query.
3.Take a table visual in PowerBI Desktop and add all the 3 fields and sort it by clicking on . column (which we added using Power Query) as shown in below image.

4. Now make the last column very small that it can not be visible by dragging it towards left.
5. After all the steps it will look like the below image.

I know there might be many ideal ways to do this but if this post helps you or you find it intresting then give it a kudos and mark it as a solution.

Thank You.