cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Can we customize the relative date filter to have Fiscal year

Hello Team,

 

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

 

 

 Capture.PNG

 

 Thanks,

 Kalyan..

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Can we customize the relative date filter to have Fiscal year

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

View solution in original post

3 REPLIES 3
Highlighted
Resolver II
Resolver II

Re: Can we customize the relative date filter to have Fiscal year

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

Highlighted
Microsoft
Microsoft

Re: Can we customize the relative date filter to have Fiscal year

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

View solution in original post

Highlighted
New Member

had this Re: Can we customize the relative date filter to have Fiscal year

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors