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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors