Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
amandabus21
Helper V
Helper V

Relative Date Filter

Hello,

 

I am trying to place a filter for this visual where I woud like the relative date filter to be "this fiscal year"ours is July - June. 

So currently it would dispay July 2023 - Sep 2023. (september since it is the last closed out)

 

Is there a way I can add this in?

 

amandabus21_0-1696361133591.png

 

1 REPLY 1
some_bih
Super User
Super User

Hi @amandabus21 

Possible solution is to create "Fiscal year" in your calendar / Date table, check link and search fiscal

https://www.daxpatterns.com/standard-time-related-calculations/ 

 

Adjust part for your fiscal need in part below. When you have fiscal columns it should be easier to slice and dice.

Hope this help, kudos appreciated.

some_bih_0-1696413211260.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.