Horizontal slicer: Custom sorting

[Marcky]

Hello there,

Is there a way to custom this Horizontal Slicer? cos i want it to sort by the value of MCI count below.

Thank you.

 

Senior_VP	MCI Count
Aaron	1
Amanda
Balaji
Christine
Christopher 1
Christopher 2
Duane
Gregg
James	9
Jennifer 1
Jennifer 2
Jordan
Joshua
Juliette
Maria	1
Mike
Muhammad
Ramiya	3
Sharon
Srikanth
Susan
Trung
Usman
Vivek

[Anonymous · Accepted solution]

Hi @Marcky ，

Accoridng to your statement, you want to sort [Senior _VP] by [MCI Count]. As far as I know, Power BI supports us to sort one column by another column. 

For reference:

Sort one column by another column in Power BI

So, firstly, please make sure [MCI Count] is a column instead of a measure. Then in your sample, I find that there are duplicate counts for different [Senior _VP], like Aaron count =1,Maria count =1.

Duplicates will confuse Power BI and then sort will return error. If the count for [Senior _VP] are all different and [MCI Count] is a column , it will work. 

Note: Calculated column may cause this function return a circule error. It is better for you to create a custom column in Power Query Editor.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.