Sorting Month Columns

[Safdev]

Hi Team,

I have been experiencing some issues sorting columns by months June 2017 through May 2918. They appear from january (2018) to december (2017). Going through the forum I learnt about bringing a separate table for Month ID and creating a relationship using the serial number to do the sort.

But I am still not getting the result after several attempts.

Please see pictures below for your easy reference. Would be grateful to receive your support.

[Safdev]

I meant "...starting from June 2017 through May 2018". Thanks

[v-qiuyu-msft · Accepted solution]

Hi @Safdev,

You can create a active relationship between the fact table with month table, then set the month name sort by the desired sort order column.  You can take a look at attached pbix file. 

Best Regards,
Qiuyun Yu