Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Specific Row on Top

Hi All,

I have a table like this, even after sorting in asc or desc I want alex will be in top always, how can we achieve this in power bi

NameMark
Alex50
Praveen45
Santhosh60
Naveen70

 

NameMark
Alex50
Naveen70
Santhosh60
Praveen45
Need Help

1 Reply

  • barritown's avatar
    barritown
    Solution Sage
    3 years ago

    Hi,

     

    If you want to adjust such a sorting in Power Query, try adding a new column called "Priority" and then apply this solution - https://community.powerbi.com/t5/Desktop/Sorting-a-table-using-multiple-columns/m-p/447941

     

    See a test case with your data:

     

     

    Update:

     

    If there is a limited amount of such VIP names in your table, the conditional column for sorting may look like:

     

    *Don't forget to adjust the format so the output value is number, not text.

     

    And then you just choose this newly created column as a column used for sorting Mark: