Can we customize the relative date filter to have Fiscal year

[kkalyanrr]

Hello Team,

Can we customize the relative date filter to have Fiscal year as well?

 

 Thanks,

 Kalyan..

[EndelGS]

Just had this same problem and this is how I solved:

• Create a new column FY Date
• FY Date = DATEADD(YourTable[DateField].[Date],-3,MONTH) // Our FY starts in april
• Use relative date filtering on FY Date

This sets April 1st as a "synthetic" January 1st so you can apply relative filters on FY Date and display using DateField

[v-huizhn-msft · Accepted solution]

Hi @kkalyanrr,

Up to now, we can not customize the relative date filter to have Fiscal year, please review the following feature requests and vote them. Power Bi will become better after your support.

customize the relative date filter to have Fiscal year
Dynamic Date Slicer (improve relative date slicer)

Best Regards,
Angelia

[sgsukumaran]

Fiscal year would be different for each organization and it would be difficult to configure in Relative filter.