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
seenai
Helper II
Helper II

Custom Sorting not working

Hi,

 

In the below example I need to SORT the data based on date.

Visual : Maintenance Cost

X-Axis : Year & Month are text data.

RELATION : The Date fields in MAINTENANCE data and master table MONTH_YEAR are related.

 

Help me to sort the data.

 

Sort1.jpgSort2.jpg  

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@seenai - Go to the Model View, and set the following property for the Month:

Sort By Month Number.PNG

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Ideally the relationship should be from the Date column of Maintenance Cost and KPI MfgExp Table to the Date column of the Calendar Table.  From the Month column of both Tables, we should be able to create another column in each Table with proper dates.  The benefir of this approach will be that you will be use Date/Time Intelligence functions with ease.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@seenai - Go to the Model View, and set the following property for the Month:

Sort By Month Number.PNG

@Anonymous 

Great!!

I have been searching for this solution from the today morning.

Thank you very much. Smiley Happy

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.