Slicer of Relative Date type is only working with PBI desktop but not on the page

[Cristinacn]

I have this PBI report built and running for years, suddenly the date slicer of relative date seems locked and not allowing any selection by clicking on the page, when I click "Edit" on the page it won't work either, but when I download the pbix file to local harddrive and edit it, it works just fine.  I re-published the pbix to workspace and it doesn't work again.  Any trick to solve that?

[Cristinacn]

Thanks all for your kind replies!  I've tried to follow some of the steps you mentioned above and it didn't work either. It turned out it was the company level server issue and IT has already fixed it now, so it's working just as normal.  But again, thank you for all your prompt and kind help here!!! 😃💓

[Anonymous · Accepted solution]

Hi, @Cristinacn 

Thanks for the feedback! Glad to hear that your problem has been solved. If you'd like, you can mark this reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for participating! 😀😀

Best Regards

Jianpeng Li

[Anonymous]

Hi, @Cristinacn 

Are you able to provide some screenshots that don't contain private information? to determine the cause of the problem. You can first try the following steps to check the cause of the problem:
Create a new calculated table in your report using the following DAX expression:

Table 2 = CALENDAR(DATE(2024,1,1),DATE(2024,3,1))

Create a date slicer with the columns of this calculated table and publish it to Power BI Service and check if it works.

If it is successful, there is a problem with the original date column.
Similarly, here's how to troubleshoot report-level issues:
Create a new test report with only a date table, publish it to Power BI service, and check if it's working.

If the report works properly, then there is a problem with the original report settings, and we can check the relevant settings.

If you're in a non-UTC time zone, this is also something we need to consider.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[grazitti_sapna]

Hi @Cristinacn,

This sounds like an issue where the relative date slicer isn’t working as expected on Power BI Service but functions fine in Power BI Desktop. Here are a few steps to try, as this can happen for several reasons:

1. Clear Browser Cache and Cookies

• Sometimes the cache may cause strange behaviors in Power BI Service. Try clearing the cache and cookies for the browser you’re using to view Power BI.
• Alternatively, try opening Power BI Service in a different browser or incognito mode to see if the slicer responds.

2. Check Power BI Service Settings

• Power BI Service may have settings affecting the report’s behavior. Ensure that Report Reader permissions are appropriate for users interacting with the slicer.
• Check that the Data is up-to-date and has loaded properly on the Power BI Service.

3. Verify the Time Zone on Power BI Service

• Relative date slicers in Power BI are sensitive to time zones. Ensure that the time zone settings for Power BI Service are aligned with the data's intended time zone.
• In Power BI Service, relative date filters sometimes behave differently because it uses UTC. For accurate relative date filters, you may need to account for time zone differences by adjusting the slicer settings accordingly.

4. Use “Date Only” in the Data Type

• If your date field includes both date and time, the slicer may have issues in Power BI Service. Change the data type of the column used in the slicer to “Date” (without time) in Power BI Desktop, save, and republish.

5. Update Power BI Desktop and Service

• Ensure that Power BI Desktop is on the latest version, as sometimes, mismatched versions between Power BI Desktop and Power BI Service can cause slicers to malfunction. Update and re-publish if needed.

6. Recreate the Date Slicer

• If the slicer still doesn’t work, try deleting it and then re-adding it in Power BI Desktop. Re-publish the report to see if this resets the slicer in Power BI Service.

7.Open a Support Ticket (Pro Account)

• If you have a Power BI Pro account, you can open a support ticket for free. Go to Power BI Support, scroll down, and select "CREATE SUPPORT TICKET."
  
• Submitting a ticket ensures that Microsoft’s support team is aware of the issue and can provide dedicated assistance or an update if it's a known bug.
  

These steps should help troubleshoot why the slicer works locally but not in Power BI Service. Let me know how it goes!

If I have resolved your question, please consider marking my post as a solution. Thank you!

[lkalawski]

Hi @Cristinacn,

Please try to download the report, remove the slicer and add again to the report. Perhaps the visualization data encoding has changed and needs to be recreated and saved with the appropriate structure.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin