Advanced Date Filter Automatically adds current time

[Anonymous]

Hi All, 

I recently noticed that when i add a date filter in my filter panel, switch it to advanced with 'is', select a date: it will add the current hour and minutes to it. 

How can i change this? 

i use a seperate date table, with just dates, no times attached. And i want to filter my report using the filter panel. Seemed to be working before, but now it doesnt. When I change back the time to 12:00 AM, it works again. 

I want to prevent the time slot from filling, as i'm just looking for a specific date. I hate to use a slicer on the report, all my filters are hidden in the filter panel 🙂 

No date selectedWhen a date is selected

[amitchandak]

Change the data type date from datetime

[Anonymous]

Hi Amitchandak, 

That is the first thing I tried. It's set to a date type. It seems to work okay in the desktop, but it fails in the service. 

Here is the filter and the table

[v-chuncz-msft · Accepted solution]

@AndreLap

You can refer to the following message.

https://community.powerbi.com/t5/Issues/Advanced-filter-for-dates-is-not-working-properly/idi-p/1047...

[Anonymous]

Thank you @v-chuncz-msft ! I will keep an eye on that post for a solution