Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Thiri
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

1 ACCEPTED SOLUTION
Thiri
Frequent Visitor

The sorting is ok with Tooltip field. Thanks.

View solution in original post

4 REPLIES 4
Thiri
Frequent Visitor

The sorting is ok with Tooltip field. Thanks.

Thiri
Frequent Visitor

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

amitchandak
Super User
Super User

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

@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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.