Thank You for posting your query onto the Forum.
Yes, you can definitely achieve this result. While loading/generating the date table just specify the starting month of your Fiscal Year in this case since it’s April just mention 4 under the “FYStartMonth” option and load it in your data model.
And then drag the “FY” field into slicer and select any FY and you’ll have the months as per the “Fiscal Year”. Below is the screenshot provided for the reference -
I’m also attaching the working of the PBIX file for the reference.
Hoping you find this useful and meest your requirements that you’ve been looking for.
Thanks and Warm Regards,
Fiscal Year Results - Harsh.pbix (667.2 KB)