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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors