How to sort Month name in slicers as per financial year

[Sajid02]

I have tried to create a month slicer wherein i would like to display month name as per financial year i .e start from April and ends up in March . 

I have created a column per accounting period and month name , but when trying to sort it by accounting period, changes is not affecting by this . 

Even after this sorting , months in slicers are not getting impacted by this and showing like the first image only .

Help me on this issue .  Many Thanks !

[amitchandak · Accepted solution]

@Sajid02 , Create a month year sort column for month year

if(month([Date]) <=4, (YEAR([Date]) -1)*100 + month([Date]) +9, (YEAR([Date]) )*100 + month([Date]) -3)

for month sort

month Sort =

if(month([Date]) <=4, month([Date]) +9,  month([Date]) -3)

[Sajid02]

Thanks a lot  !  Solved my problem .

One small changes however required to do  as instead of 4 in the Dax we have to use 3 to get April as 1 and so on.