Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
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:
This also appears to only be the case when using the Month selection. Last X Weeks or Last X Years include the first date:
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.
I have attached my sample for others to look at.
Solved! Go to Solution.
Hi @jdbuchanan71 ,
This issue has been reported internally. I will update the progress in time.
Best Regards,
Icey
Thank you for the update @Icey . Also, here is a link to the issue I submitted on this item.
Here is a better illustration just using MIN ( Dates[Date] )
It sure does look like a bug...does it happen for every month?
Proud to be a Super User!
Paul on Linkedin.
It seems to, yes. No matter how many X months you select it always drops the first date.
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.
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).
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)
Proud to be a Super User!
Paul on Linkedin.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
137 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |