Fiscal Period Sorting by Month

I have a sales data table which is only referencing a Period as the month e.g. 1 - 12. From that I have created a period lookup table and set 1 - April as our Fiscal Year runs from April-March

What I am now finding is whenever I add this onto visuals in Matrix it cannot keep this order and is sorting by the period number or the Month name in a random order. I suspect I need to create a new measure/column but not sure how to achieve this - examples I have seen are able to do this as there is date data but in my sample it's sorted by a period number at the lowest level.

How can I achieve this?

Thank you