Custom Sorting not working

[seenai]

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.

  

[Ashish_Mathur]

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.

[Anonymous · Accepted solution]

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

[seenai]

@Anonymous 

Great!!

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

Thank you very much.