cancel
Showing results for 
Search instead for 
Did you mean: 
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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors