Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Marcky
Frequent Visitor

Custom sort based on another value that has contain many blanks

Hi there

 

would like to seek your help to geting sort the visual with these data

 

This is the visual that i want to sort based on the value of MCI

Marcky_0-1666335189852.png

 

This is the reference data

 

Senior_VPMCI Count
  
Aaron1
Amanda 
Balaji 
Christine 
Christopher 1 
Christopher 2 
Duane 
Gregg 
James9
Jennifer 1 
Jennifer 2 
Jordan 
Joshua 
Juliette 
Maria1
Mike 
Muhammad 
Ramiya3
Sharon 
Srikanth 
Susan 
Trung 
Usman 
Vivek 

i hope you can help me with this

1 REPLY 1
lbendlin
Super User
Super User

replace the blanks with an appropriate value (for example 0 ). Add a small random number to break ties.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors