Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MarkWill
Frequent Visitor

Relative Date Last 1 Calendar Month Not Working

Hi
I have found this morning that my date slicer that is set to Last 1 Calendar Month is no longer working. I have a Date table and it is using a Min and Max value of a tables timestamp column which is date only, no time values.

At the time of this post it was 01/12/2022 (dd/mm/yyyy). So the slicer should be showing a date range of 01/11/2022 - 30/11/2022 (dd/mm/yyyy)

If I choose This Month it shows the correct date range (November).

While typing this post I refreshed the BI file and it has now changed to the correct date range since 11.00am. So it is using UTC time. I'm in Australia with daylight savings at the moment.

I haven't seen this issue before and was wondering if there may have been an update to BI Desktop in the background recently that has caused the issue?

 

Thanks

2 REPLIES 2
amitchandak
Super User
Super User

@MarkWill , Power bi November 2022 update is released, if you see teal(green) color on startup screen or on + button, then it nov release.

 

you can issue at https://community.powerbi.com/t5/Issues/idb-p/Issues

Thanks for replying amitchandak. I do have the teal startup screen. 

I have pasted my post in the issues page.

Thanks.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.