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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.