Skip to main content

Power BI

Needs Votes

Financial Year and Quarterly Relative Date Filter Options

Vote (332) Share
Shea Woolnough's profile image

Shea Woolnough on 18 Aug 2017 07:28:57

I have come across a few occasions where it would be great to have the following options in the relative date slicer:

- Quarter
- Financial Year

This would be a great addition to the already immensely useful slicer.

Comments (38)
Shea Woolnough's profile image Profile Picture

Steven Myers on 26 Mar 2021 11:59:11

RE: Financial Year and Quarterly Relative Date Filter Options

Adding quarters to the relative date filter would be a great addition. Currently, I have to do workarounds for quarters.

Shea Woolnough's profile image Profile Picture

Narissa Tuawhiorangi on 05 Oct 2020 22:37:51

RE: Financial Year and Quarterly Relative Date Filter Options

I went searching on how to do this. This is just what I need

Shea Woolnough's profile image Profile Picture

Jacob Scherb on 24 Sep 2020 17:26:04

RE: Financial Year and Quarterly Relative Date Filter Options

Please add this. It would make PARALLELPERIOD measures so much more efficient.

Shea Woolnough's profile image Profile Picture

Lance Landenberger on 06 Jul 2020 00:17:15

RE: Financial Year and Quarterly Relative Date Filter Options

Please add this.

Shea Woolnough's profile image Profile Picture

Pär Adeen on 06 Jul 2020 00:16:35

RE: Financial Year and Quarterly Relative Date Filter Options

Please add this filter.
Yes it's possible to create time intelligence measure to compensate for this, but sometimes it's convenient to just use these relative filters instead

Shea Woolnough's profile image Profile Picture

Simon Power BI User on 06 Jul 2020 00:13:06

RE: Financial Year and Quarterly Relative Date Filter Options

Agreed - this would be a huge help, not only for my team but the entire business. I see this thread has gone back two years, is this something that will be implemented?

Shea Woolnough's profile image Profile Picture

Ramon on 06 Jul 2020 00:12:51

RE: Financial Year and Quarterly Relative Date Filter Options

I need this for my report. Quarter in relative filtering will make life easier and the team usually request it

Shea Woolnough's profile image Profile Picture

Brian T on 06 Jul 2020 00:08:54

RE: Financial Year and Quarterly Relative Date Filter Options

I've got my CISO and CTO of a very large fortune 100 entity about to examine reporting for which they desire to easily filter by Quarter. As the entire purpose of what we created was to automate and have autonomous refresh from the BI Gateway to the Service, they will expect this. If it's not there, this may be another reason to consider Tableau - we make big crayons for a reason and simplicity needs to be there for their uses. Even with a time filter, it still gets too unwieldy with all the queries we have as it is connected to the enterprise. I need this to happen

Shea Woolnough's profile image Profile Picture

Ryan McClelland on 06 Jul 2020 00:03:15

RE: Financial Year and Quarterly Relative Date Filter Options

Surprised this isn't already a thing considering everything else Power BI can do, should be standard in relative date filtering. Really need this update!

Shea Woolnough's profile image Profile Picture

Mary on 06 Jul 2020 00:03:00

RE: Financial Year and Quarterly Relative Date Filter Options

We need to use a fiscal date as well as calendar date. The relative date allows dynamically finding the current month and year. It would be great if we could extend it to the fiscal month and year.

Merged Idea (5)