Sorting of small multiples in Clustered column chart not working

[Thiri]

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.

[Thiri · Accepted solution]

The sorting is ok with Tooltip field. Thanks.

[Thiri]

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

[amitchandak]

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

[Thiri]

@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?