Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Technowolf

Relative Date Filtering complete including today

Submitted by Helper II on ‎05-20-2019 02:28 AM

Hi

This filter is not filtering last  5 months including day. I am not looking for completed months but total of 5 month which includes today, which means 4 completed months and current month including today.

 

its does not filter last 6 months but last 180 daysits does not filter last 6 months but last 180 days

Regards,

Charles Thangaraj

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-20-2019 07:49 PM

Hi @Technowolf, 

 

For relative date filtering mode, it works like below: 

 

If we select Months from that list, and input 2 in the middle setting, the following would happen: if today is July 20th, the data included in visuals constrained by the slicer would show data for the previous two months, starting on May 20th and going through July 20th (today's date).

 

In comparison, if we selected Months (Calendar), the visuals constrained would show data from May 1st through June 30th (the last two complete calendar months).

 

For your requirement, it's not supported to achieve it currently. You need to go to Basic Filtering or Advanced Filtering mode to specify date range manually. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses