cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User II
Super User II

Relative date slicer bug? - Last X Month ignoring first date

I wanted to verify that others are seeing the same behavior I am.

When using a relative date filter and the Last X Months option, the first date in the range is being left out.

I put together a simple model to show the issue.  You can see that I do have data for 8/31/2020:

jdbuchanan71_0-1601479974817.png

However, when selecting Last 1 Months, even though the date range is listed as 8/31/2020 - 9/30/2020 the amount for the date 8/31/2020 is left out:

jdbuchanan71_1-1601480265031.png

This also appears to only be the case when using the Month selection.  Last X Weeks or Last X Years include the first date:

jdbuchanan71_2-1601480358784.png

I also tested with a couple of cards where each date slicer only applies to the card next to it.  The Between setting is fine and the first date is included in the calculations.

jdbuchanan71_3-1601480532907.png

I have attached my sample for others to look at.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @jdbuchanan71 ,

 

Microsoft reply: bug filed internally, core issue identified.

 

 

Best Regards,

Icey

View solution in original post

10 REPLIES 10
Highlighted
Super User II
Super User II

Here is a better illustration just using MIN ( Dates[Date] )

jdbuchanan71_1-1601485395534.png

 

 

Highlighted

@jdbuchanan71 

It sure does look like a bug...does it happen for every month?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted

It seems to, yes.  No matter how many X months you select it always drops the first date.

jdbuchanan71_0-1601487699187.png

 

Highlighted

@jdbuchanan71 

How about if you select a mid-month date as your final date for the period (instead of the last day of a month)? (Apologies, since I'm not at a computer so can't try myself)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted

Any other type of date filtering seems to work.  It is only the Relative Date using Last X Months where I have seen this problem.  

Highlighted

There are some values where it works "properly", For Sept (30 day month), if you go back to July (3), May (5), March (7), December (10), or October (12) it works OK.

 

2020-09-30 14_41_21-Window.png2020-09-30 14_41_09-Window.png2020-09-30 14_40_52-Window.png

2020-09-30 14_40_05-Window.png

2020-09-30 14_39_51-Window.png




Proud to be a Super User!




Highlighted

@dedelman_clng 

I thought it might be that if the month you rolled back to had 30 days then the display would step back a day but then last 2 would not break because August has 31 days and it still rolls back to 7/31/2020.

It looks to be a descrepancy between the reported filter (the one on the bottom of the date slicer and in the filter tool tip on the cards) and the real filter (the one applied in the model).

jdbuchanan71_0-1601502869450.png

 

Highlighted
Community Support
Community Support

Hi @jdbuchanan71 ,

 

This issue has been reported internally. I will update the progress in time.

 

 

 

Best Regards,

Icey

Highlighted

Thank you for the update @Icey .  Also, here is a link to the issue I submitted on this item.

https://community.powerbi.com/t5/Issues/Relative-Date-slicer-Last-X-Months-drops-first-date/idc-p/14...

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors