Forum Discussion

apmulhearn's avatar
apmulhearn
Helper III
1 year ago
Solved

Date Slicer Causing Issues in Desktop

Hello,   I have a report that has worked fine for about 4-5 years with minimal maintenance. It is published to the online service and it updates automatically 4x per day without issue. Recently...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi apmulhearn 

    Thank you for reaching out to Microsoft Fabric Community Forum. Also thank you ray_aramburo for your quick response.

    We understand that you are experiencing issues with date slicers and visualizations crashing when modifying the earlier side of the slider in Power BI Desktop. Based on our analysis and feedback from other users, this appears to be a known issue introduced in the March 2025 update (version 2.141.1228.0) of Power BI Desktop.

    Please note that this issue does not affect the Power BI Service, where reports continue to function and update as expected.

    As a temporary workaround, we recommend rolling back to the February 2025 version of Power BI Desktop, which has resolved the issue for several usersDate Filter Error - Microsoft Fabric Community

    You can download the previous version from the Power BI Previous Monthly Updates page.

    Additionally, we suggest raising a support ticket with Microsoft to help prioritize a fix in future releases. If you have already submitted a ticket, we appreciate your patience as Microsoft works towards a resolution.

     

    You can submit a ticket through the Microsoft Power BI Support Portal:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

    Regards,

    Karpurapud,

    Microsoft Community Support.

ray_aramburo's avatar
ray_aramburo
Super User
1 year ago

Hi apmulhearn ,

Having a calendar table that goes up to Year 3000 (good song by the way) is not the best idea and that's what likely is causing the issue. Adjust it to Date Table = CALENDAR(Date(2000,01,01),Date(2027,12,31)) at least. 

apmulhearn's avatar
apmulhearn
Helper III
1 year ago

Thank you for the reply. The date range has been that large for 4 years without issue, but I have been adjusting it all day as a possibilty. It is presently 1/1/2000 - 1/1/2030, and still failing.

I also had a colleague download the file. She is able to open it and adjust the dates without any issue. It seems to be very specific to me. I am now wondering if it might be related to my Surface Snapdragon/ARM processor?


  • ray_aramburo's avatar
    ray_aramburo
    Super User
    1 year ago

    If it works fine in Service but not in Desktop then yes, your RAM might be the issue.

    • apmulhearn's avatar
      apmulhearn
      Helper III
      1 year ago

      Not RAM, ARM. But either way, this was not the issue. It appears to be a bug in the March/April, as mentioned elsewhere. Thank you very much for looking into it, though.

      • v-karpurapud's avatar
        v-karpurapud
        Community Support
        1 year ago

        Hi apmulhearn 

        As I mentioned in my earlier response, it is advisable to contact Microsoft Support regarding this issue since it is a known limitation. Reaching out to the support team would be the best way to resolve it.

        Thank You!