Power BI
Needs VotesNeed a relative dates filter allowing "calendar months" including current MTD
Quinn Clark on 2017-12-27 03:00:13
Current page-level filters allow us to look at relative months and years as simple "months" or "calendar months". "Calendar months" always excludes the current MTD, but that's exactly the range that I'm often looking for: Select data for whole prior months and MTD for the current month.
- Comments (18)
- Merged Idea (6)
Asaf Tannenbaum on 2020-11-14 22:09:49
Relative Date Slicer to allow full months in the past and partial current month
Today you have only two options to filter months in the page level, with the relative option Assume we are now in the middle of Nov. 2020 and I want to show the last 6 months dynamically. When I select Last 6 months, I get all the data starting from November 15th back -180 days. It is not cove...
Ty Garner on 2021-01-28 00:59:32
"Include Current" Option for Relative Date Filters with "Calendar" periods
An "Include Current [Week; Month; Year]" option for the Calendar Weeks, Calendar Months and Calendar Years selections of the Relative Date filter. For instance, I use my [Date] column as a filter and choose the following: "Filter Type: [Relative Date] Show items when the value: [is in the last]...
Arnoh on 2019-08-04 12:55:51
relative date filter add option including current year
Hi, I miss the option to include the current year when filtering on calander year, month etc. When i now filter i get only the values of the previous periods and not the current period. Thanx
Alex Sazonov on 2018-11-21 06:22:54
Change "Last" year/month, etc relative date filter to include current YTD and full Prev. Year.
When doing a relative date filter, it should help users make easy YoY or YTD vs PYTD comparison. "Last" 2 years function seems unusable because it does not conform to general business requests.
Nick on 2017-11-06 23:55:36
Relative Date Slicer Improvement: This & Last
An improvement I'd like to see on the relative date slicer is the ability to select an option for "This and Last" xx "Years/Months/Days/etc". So if I want to compare at a glance a chart with this year's numbers with the last 2 it would be a lot easier.
Sean McLarty on 2020-05-14 06:13:30
Allow Relative Date filter to include today's date for "calendar months"
When you choose "last 12 calendar months" it would be useful to include the current month. It's frustrating that the end date is for last month and not today's date. Maybe don't hide the "Include today's date" option that appears for "last 12 Months". Or, add another option named "Include cu...