Change Fiscal Year Default From Jan1-Dec31 to Mar1-Feb28

[nfowler_PDR]

Hello,

Is there a way to adjust the Fiscal Year settings to a Date Hierarchy slicer in Power BI Desktop?

I have the below:

 

Above, it gives standard FY layout.

But I need this to reflect our internal FY layout of March 1st to February 28th.

There currently is not FY table in the dataset.

I created this dataset from our CRM database in out Dynamics dataverse. 

Thank you!

Nat

[ryan_mayu]

@nfowler_PDR 

are you able to use DAX to create column? if you can do that ,you just need to create new columns for fiscal year and replace the origial date column with new ones.

fiscalyear = if(month('Table'[Date])in {1,2},year('Table'[Date])-1,year('Table'[Date]))

fiscalmonth = if(month('Table'[Date])>=3,month('Table'[Date])-2,month('Table'[Date])+10)