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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0
niccupp

Relative Date Slice - Show Last Month on the 1st when Include Today is set to No

Submitted by on ‎07-01-2017 04:44 AM

I am using relative date slicer on one of our reports with "Include Today" set to "No" and the default value is show "This Month".

 

 

Today is the 1st and it's showing "This Month" = 7/1/2017-7/31/2017. I expected it to still say 6/1/2017-6/30/2017 since we are not including today.

 

Is this a bug? 

 

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎07-04-2017 12:07 AM

@niccupp

 

I’ve reported it internally to Power BI Team: CRI 41570762
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎07-04-2017 12:08 AM
Status changed to: Accepted
 
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎07-17-2017 07:57 PM

@niccupp

 

I’ve got response from the Product Team.

 

This is by design. The include today works only for relative non calendar ranges [Last/Next non calendar periods].

For This and Last/Next Calendar [weeks/months/years], it is evaluated always with respect to the current date. Include today does not have any effect. 

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎07-17-2017 07:57 PM
Status changed to: Delivered
 
niccupp
Regular Visitor
‎07-18-2017 05:48 AM

Is there some way that I can program the slicer to look at This Month unless today is the 1st of the month, then look at Last Month? 

Idea Statuses