sort horizontal matrix column by Fiscal year Month

[dhirenp77]

What is the best way to sort the fiscal year data by month?

I am using matrix visual.  first column is data source and i want to show values for each source in month column.  Month should be sorted by fiscal year starting in Nov. 2017-> Oct 2018.

I can have two rows year, month which will sort.  But i just want to show the Month names and the they should just be in fiscal year month sequence.  

Any feedback on how to accomplish will be very helpful.

thanks

[v-yuezhe-msft · Accepted solution]

@dhirenp77,

You can create sequence number for your fiscal year month(Nov. 2017-> Oct 2018), the click the YearMonth column, and sort the column by the sequence number column. There is an example for your reference.



Regards,
Lydia

[dhirenp77]

Thanks.  That is exactly what i ended up doing.