Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
Solved! Go to 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.
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.