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
Santho_BI
Helper I
Helper I

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
1 REPLY 1
barritown
Super User
Super User

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:

barritown_0-1679301805944.png

 

 

Update:

 

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

 

barritown_0-1679314588406.png

*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:

 

barritown_1-1679314848380.png

 

 

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.