Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Customized sort column in descending order in small multiples

Hi Expert,


I had a visual with small multipes in below.
User need to select "Sort by 2023" filter (with option: descending & ascending) to sort the result accordingly. Kindly ask how to do that ?

I've try create sepeate year table and link with key data table, then create measure and place in visual tooltips, this work if I didn't use small multiples, however, I need that and another seperate filters for sort by ascending & descending order.


Thanks a lot for yours help.






Community Support
Community Support

Hi  @TWMY1014 ,


Are you referring to sorting small multiples, you can check out the following link:

Small Multiples Custom Sorting and Pagination in Power BI - BI Elite

Solved: Sort Y-axis on stacked bar chart with small multip... - Microsoft Power BI Community


Best Regards,

Liu Yang

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

Helpful resources

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