Specific Row on Top

[Anonymous]

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

Name	Mark
Alex	50
Praveen	45
Santhosh	60
Naveen	70

Name	Mark
Alex	50
Naveen	70
Santhosh	60
Praveen	45

[barritown]

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: