Forum Discussion

lutzb's avatar
lutzb
Regular Visitor
1 year ago
Solved

Relative Date Filter suddenly stopped working

Hi all, 

 

from one day to another the relative date filter stopped working and no visuals can be displayed on which a relative date filter is applied. I did not change any settings or whatsoever. I checked the Windows time zone and date as well as format and everything is equal to PowerBi. It also has nothing to do with the date tables since the problem persists in different dashboards using different calendars or date tables. Anyone experienced that problem before? 

Need Help

8 Replies

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

    Hi lutzb,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    It looks like this seems to be a systemic issue rather than something limited to a single dataset or report.

    • Relative date filtering only works when the target field is explicitly of type Date or Date/Time. Even if the column type is correct, the table needs to be marked as a Date Table in power bi.
    • If you are using the power bi service, the session or cache issues may prevent filters from applying correctly. Clear the browser cache and try using Incognito Mode and also test it in a different browser.
    • A failed dataset refresh may cause the filter to return no values. Try a manual refresh and confirm that the data is loading correctly or not.
    • In some cases, the existing relative date filter or slicer gets corrupted after updates. Try to remove the current relative date filter/slicer and add a new one using the correct date column.
    • Also there have been recent reports where relative date filters stopped working due to some backend changes in power bi service.  Check if there are any known issues
      https://support.fabric.microsoft.com/en-in/known-issues

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

    • lutzb's avatar
      lutzb
      Regular Visitor
      1 year ago

      Good evening, 

       

      Thank you for your reply. Unfortuately, it does not resolve the matter. 

       

      • Relative date filtering only works when the target field is explicitly of type Date or Date/Time. Even if the column type is correct, the table needs to be marked as a Date Table in power bi. - We are aware and we built multiple functioning dashboards. But as said, from one day to another, all visuals using Date filters are corrupted and no dashboard is useable anymore. 
      • If you are using the power bi service, the session or cache issues may prevent filters from applying correctly. Clear the browser cache and try using Incognito Mode and also test it in a different browser. - we are using PowerBI Desktop.
      • A failed dataset refresh may cause the filter to return no values. Try a manual refresh and confirm that the data is loading correctly or not. - I did not mention any issues to refresh because there are no issues with refreshing. Hence refreshing does neither cause nor solve the problem. 
      • In some cases, the existing relative date filter or slicer gets corrupted after updates. Try to remove the current relative date filter/slicer and add a new one using the correct date column. - It does not matter what we remove. The moment we apply a date filter to any of the visuals in any of the dashboards with any data source, the visual crashes and gives us the following helpful error message: 

      "Unexpected error (file "", row , function "").

       

      • Also there have been recent reports where relative date filters stopped working due to some backend changes in power bi service.  Check if there are any known issues. - No issues reported mentioning the date filter. 

      Unfortunately no dashboard can be used anymore, the problem persists and management is already about to dump PBI for it.

       

      So maybe someone has some good idea, what could be causing the issue?

  • nickshot's avatar
    nickshot
    Regular Visitor
    1 year ago

     

    I have this exakt problem. It is only in Desktop. In Service it still works and keeps autoupdating correct. If I use Desktop February version it also works. The problem is with all Desktop versions later than that, even the May version release just the other day.

  • jsandoval84_IWH's avatar
    jsandoval84_IWH
    Regular Visitor
    1 year ago

    We are experiencing the same issue, relative date range filter suddenly stops working in Power BI desktop. It is only happening to one user on one report right now.

  • sherry_amelse's avatar
    sherry_amelse
    Frequent Visitor
    11 months ago

    Did you ever get a solution to this issue?  I've been struggling with this for months and can't figure out how to fix or work around it.  I'd really appreciate any advice or ideas you have.