Date Filter not applying to service - only desktop

[kieranb123]

Hello,

I have put a filter on my table to only show data where CREATE_DATE is in the previous 12 months. I have a date slicer in my report that updates accordingly to the last 12 months in the desktop version. When I publish and open the report in the service, the same slicer is showing the entire date range going back 3 years to todays date. It also acts very buggy - if I change the end date section in the slicer in the service to any other date other than todays, it filters the data in the report to the correct data (as shown in the desktop version). If it stays as todays date as the end date, ti shows all data in the table.

[kieranb123 · Accepted solution]

Thank Gilbert - I could not figure it out. I simply removed the slider and re added it and for some reason that resolved the issue. Cheers

[Anonymous]

Thanks @GilbertQ .

Hi  @kieranb123 

If you've already addressed the issue at hand, you can mark your response so you can help others in the community find answers quickly when they encounter similar issues. Thank you very much.

Best Regards

Jianpeng Li

[GilbertQ]

Hi @kieranb123 

Can you please confirm that you have created a relationship from your main table to your date table to make sure that the slicer works as expected?