Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Advanced filter for dates is not working properly



There seems to be an issue with the advanced filter option when filtering a date. When I select a date from the date picker, I can simply apply the filter as normal (see screenshot 1). However, once I type the date, or I change anything in the time-section of the filter, the time changes to 1:00, and I am unable to select a.m./p.m, and thus unable to apply the filter, with the "Apply filter" remaining greyed out (see screenshot 2). The only "fix" is to refresh the page, and use only the date part of the filter, and let Power BI automatically fill in the time-part. In Desktop, there is no problem, the same filter on the same report works as it should.






Status: Accepted
Advocate I
Frequent Visitor

Os Problema no Filtro permanece

A data deve ser DD.MM.AAAA está invertendo automático para MM/DD/AAAA depois de ativar o filtro, isso ocorre tambem quando utilizo o filtro entre duas datas.
(é igual ou está depois E é igual ou está antes)



Advocate I

Exactly, I experiencing the same as @sulcatarinense , the filtering problem is still there.   As suggested from @v-qiuyu-msft  I have opened a new post therefore (you can find the link in the comment above)

Community Support

Hi @max_31


One of our team member owns your thread and he will reply to you in your new thread, you can follow up there. 


@sulcatarinense It looks like you have the same issue as @max_31, you can comment in @max_31 's thread as well. By the way, please post a reply in English so we can understand the issue clearly. 


Best Regards,
Qiuyun Yu



Not applicable



I tested advanced filter, but when using filter options "is exact or an after" and "is exact or before" and the time is still working bad. It shows me my actual windows time as only one possible option (can't change it). Second thing is, that button for using filter also doesn't work for me.


Have a nice day,

Tomasadvanced filter problem.JPG