Sort Custom Date Column in Array

Hello Syndicate_Admin 
As per you use case If you're using only month values then you can just change your column value format like below attached image and order the Fecha column by Orden column
Note : You should change the Orden column datatype to Whole Number

Thanks & Regard...

Hi Syndicate_Admin,

Thank you for reaching out with your question. It sounds like you're trying to sort a date column in your matrix visual based on the fiscal year, starting from April. You're on the right track by creating a custom column that assigns numbers to each month. To make this work effectively in Power BI, you'll need to ensure that your original date column is sorted by this custom column. You can do this by selecting the date column, going to the "Modeling" tab, and choosing "Sort by Column," then selecting your custom fiscal month number column.

Make sure that your custom column has no blanks and correctly matches the months from your date column, and also check that both columns have the appropriate data types, your date column should be of type "Date," and the custom sort column should be "Whole Number." Once sorted, your matrix visual should reflect the correct fiscal month order. 

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.

Thank you so much for the reply, but it didn't work for me.

The Order column is set as an integer and the date column is set as a date, I sort it according to the Order column, but it doesn't work for me.

I leave a screenshot, (how can I attach the pbix file?)

Best regards

I leave the file at the following address:

OA.pbix

Thanks a lot

Best regards