Forum Discussion
Relative Date Filter suddenly stopped working
- 1 year ago
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
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
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-achippa1 year agoCommunity Support
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-achippa1 year agoCommunity Support
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