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

Sorting of small multiples in Clustered column chart not working

I can sort numeric data in table or matrix. Some times, some numeric measure cannot be sorted on matrix. 

Currently, I created line and clustered column chart that has the following:

-Shared axis : Fiscal Year, Month hierarchy for 12 month

-Column Values: MTD TY, MTD LY

-Line Values: MTD Trend Monthly

- Small multiples: top 10 Area based on TY sales measure (MTD TY) 

I want to sort based on MTD TY as follows.  It has done and not working correctly.

2021-09-27 13_50_33-Americas Dufry Competitor Dashboard - Power BI Desktop.png

Frequent Visitor

The sorting is ok with Tooltip field. Thanks.

View solution in original post

Frequent Visitor

The sorting is ok with Tooltip field. Thanks.

Frequent Visitor

My measure is write on Azure Analysis Service. It seems not working nurmeric measure sorting in small multiples.

Super User
Super User

@Thiri , Can you share what is wrong. This will be based on grand total MTD TY for each small multiple

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

@amitchandak Thank you for your reply. I want to sort small multiples by MTD TY Monthly as follows. But it cannot be sorted by MTD TY measures. I can choose it but the graph cannot sort actually.  It only sorted by Area alphabetically. I think the small multiples cannot sort by numeric measures. Could you please suggest if there is anything wrong?

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.