Skip to main content
Microsoft Idea

Power BI

Needs Votes

Financial Year and Quarterly Relative Date Filter Options

Vote (326) 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

G E on 01 Dec 2023 16:51:44

RE: Financial Year and Quarterly Relative Date Filter Options

Is it really 6 years hard to add this?

Shea Woolnough's profile image Profile Picture

Paul Smout on 25 Sep 2023 15:18:44

RE: Financial Year and Quarterly Relative Date Filter Options

Can't believe they wrote a brilliant realative date filter and diddn't include the ability for quarters or financial periods in general e.g. we could leave our financial reports on current period when that period doesn't align with calendar months.

Shea Woolnough's profile image Profile Picture

Phillip Putzback on 25 Apr 2023 17:37:13

RE: Financial Year and Quarterly Relative Date Filter Options

Another upvote. I am working on a project where we are moving Tableau reports to Power BI, and it seems that I get a new gotcha every day from what you would expect to be functionality of any modern reporting tool. Especially one that is updated so frequently.

Shea Woolnough's profile image Profile Picture

Anthony Musillami on 31 Jan 2023 22:20:07

RE: Financial Year and Quarterly Relative Date Filter Options

Every business runs quarterly reporting. How is this not included???

Shea Woolnough's profile image Profile Picture

on 30 Sep 2021 21:47:41

RE: Financial Year and Quarterly Relative Date Filter Options

Relative date feature currently has options for days, week, month, year but not quater. And it would be really helpful to have this option as most company wide reports analysis require quaterly data. Thank you

Shea Woolnough's profile image Profile Picture

on 30 Sep 2021 21:47:34

RE: Financial Year and Quarterly Relative Date Filter Options

The existing relative date slicer options are super useful, but i often find myself being asked why it doesn't include calendar quarter by users within my organisation. Is this being considered for future development? Presumably it would be a relatively easy addition to make.

Shea Woolnough's profile image Profile Picture

on 30 Sep 2021 21:47:33

RE: Financial Year and Quarterly Relative Date Filter Options

I use relative date filtering frequently and am seeking an easier way to filter my data based on a quarterly view rather than having to used advanced filtering to set my quarter views. Additionally Quarters should be added as an option for grouping data into bins.

Shea Woolnough's profile image Profile Picture

on 30 Sep 2021 21:47:33

RE: Financial Year and Quarterly Relative Date Filter Options

In Relative Date Slicer, we have Day, weeks, weeks(Calendar), Months, Months( Calendar), Years and Years (Calendar). Please Add Quarters, Quarters (Calendar) as well and Quarter for 'This' section.

Shea Woolnough's profile image Profile Picture

on 30 Sep 2021 21:47:33

RE: Financial Year and Quarterly Relative Date Filter Options

I use relative date filtering frequently. Our organization frequently looks at data Quarter-over-Quarter. It would be great to be able to use Quarters in addition to days, weeks, months, years.

Shea Woolnough's profile image Profile Picture

Michael Kehoe on 21 Apr 2021 21:35:44

RE: Financial Year and Quarterly Relative Date Filter Options

It is hard to believe this is not an included option. How do you build a time slicer as powerful as this and skip QTRs?

Merged Idea (5)