Skip to main content

Power BI

Needs Votes

Financial Year and Quarterly Relative Date Filter Options

Vote (209) 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 (24)
Shea Woolnough's profile image Profile Picture

b8b5ea8d 1fbb-4ea7-9761-53f0dbbf9ef6 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

20e99802 0fc9-4cea-9652-f4dc9100927c 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

d083fcc6 f570-4902-bb81-6446fb24b73a 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

536ba148 2fdb-46a6-abd8-4308bc6a7a37 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

20a96057 27da-41ec-8e3c-31def14e1023 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

c3ae2bfd f3a4-4e33-baeb-ce482ee40a20 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

b25811a2 8ff7-48ab-a609-d01f9591c195 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!

Shea Woolnough's profile image Profile Picture

7b4f08c2 0481-438b-b35a-3fa5fa115075 on 05 Jul 2020 23:35:28

RE: Financial Year and Quarterly Relative Date Filter Options

I'd like to be able to filter for quarters, including:
This quarter (QTD)
Last # quarters
QTD plus previous # quarters

Shea Woolnough's profile image Profile Picture

b3db345f b13d-4661-8ccc-f896b063fe94 on 05 Jul 2020 23:35:28

RE: Financial Year and Quarterly Relative Date Filter Options

either is fine

Shea Woolnough's profile image Profile Picture

c03c29a4 5eca-4ecf-8605-9b736419df24 on 05 Jul 2020 23:32:53

RE: Financial Year and Quarterly Relative Date Filter Options

Quarterly filter is very much needed indeed, especially for OKR based reporting.