Forum Discussion

Ayappan's avatar
Ayappan
Icon for Helper III rankHelper III
3 years ago
Solved

can we remove default sorting option in data table power bi

Hi Team ,

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

P1Copper
P1Arrow
P1Zinc
 Copper
P2Arrow
P2Zinc
P3Copper
P3Arrow


But when i select this column in DataTable it is sorting 

 

P1Arrow
P1Copper
P1Zinc
P2 Arrow
P2Copper
P2Zinc
P3Arrow
P3Copper

 

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

Thanks 

Need Help
Show and Tell
  • KeyurPatel14's avatar
    KeyurPatel14
    3 years ago

    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.

3 Replies

  • KeyurPatel14's avatar
    KeyurPatel14
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    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.

  • FrankAshby's avatar
    FrankAshby
    Regular Visitor
    3 years ago

    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.

  • rachelgomez1234's avatar
    rachelgomez1234
    Icon for Helper I rankHelper I
    3 years ago

    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