Relative Date Filter suddenly stopped working

[lutzb]

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? 

[sherry_amelse]

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.

[v-achippa]

Hi @nickshot, @jsandoval84_IWH, @sherry_amelse,

Thank you for reaching out to microsoft fabric community.

Thank you for the responses, since the issue is only in the desktop, please try the above steps which I have provided earlier in this thread.

If the issue still persists, I request you to please raise a support ticket for further investigation.

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

Thanks and regards,

Anjan Kumar Chippa

[jsandoval84_IWH]

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.

[nickshot]

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.

[v-achippa]

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]

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?

[v-achippa · Accepted solution]

Hi @lutzb,

Since the issue still persists and it started suddenly and affects all reports, even newly created ones. I request you to please raise a support ticket for further investigation.

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

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @lutzb,

As we haven’t heard back from you, we are closing this thread for now. If you have any issue further, please raise a new thread in the community forum, we are ready to assist you on it. Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa