Customized sort column in descending order in small multiples

[TWMY1014]

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.

[v-yangliu-msft]

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.