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

Anthony on 06 Jul 2020 00:01:47

RE: Financial Year and Quarterly Relative Date Filter Options

Much needed in any enterprise environment with financials especially when using live connect!

Shea Woolnough's profile image Profile Picture

Andrew Lamacraft on 05 Jul 2020 23:59:52

RE: Financial Year and Quarterly Relative Date Filter Options

In the UK many of our clients will have a financial year that traditionally align to the tax year. This means the financial year ends in March. The lack of any method to use the relative date filter with a parameter or table column does mean more annual maintenance of the models.

Shea Woolnough's profile image Profile Picture

Pedro on 05 Jul 2020 23:58:44

RE: Financial Year and Quarterly Relative Date Filter Options

'+1

Shea Woolnough's profile image Profile Picture

SA_NYC on 05 Jul 2020 23:48:50

RE: Financial Year and Quarterly Relative Date Filter Options

'+1 for relative quarters.

Shea Woolnough's profile image Profile Picture

JPT on 05 Jul 2020 23:47:23

RE: Financial Year and Quarterly Relative Date Filter Options

Additionally would be great to have fiscal periods which in my case is 4 week increments.

Shea Woolnough's profile image Profile Picture

Christopher Power BI User on 05 Jul 2020 23:46:47

RE: Financial Year and Quarterly Relative Date Filter Options

I can't believe this isn't a thing! Needed!!!!

Shea Woolnough's profile image Profile Picture

Archie on 05 Jul 2020 23:39:00

RE: Financial Year and Quarterly Relative Date Filter Options

Requesting this as well

Shea Woolnough's profile image Profile Picture

Ben Rimington on 05 Jul 2020 23:37:43

RE: Financial Year and Quarterly Relative Date Filter Options

'+1 This would be really handy

Shea Woolnough's profile image Profile Picture

David on 05 Jul 2020 23:36:48

RE: Financial Year and Quarterly Relative Date Filter Options

Quarters in relative date slicer is one of my bigger wishes!

The logic needs to be a bit more complex as well. I need to be able to chose "this" and "next" quarter in some cases.

Shea Woolnough's profile image Profile Picture

David Anstee on 05 Jul 2020 23:35:59

RE: Financial Year and Quarterly Relative Date Filter Options

Yes please, most business report on Quarters, and to use this in the Relative Date filter is a MUST!

Merged Idea (5)