Forum Discussion
Helper IIAdvanced Filters - using a date but time is defaulting to current time
I have several reports where i use a date in the filter pane and have it set to the advanced view so i can pull date ranges as follows if needed:
01 JAN 2019 to 31 DEC 2020
So i select the date in the filter like below:
Date - On or After
and
Date - on or before
Apply Filter
Previously the time underneeth each date used to default to 12 AM, however now it is defaulting to the current time. When i try to change this filter it wont allow me to select AM/PM.
Is this a new feature or a bug? Does the time now get used where as it previously wasnt or is the time still not used if the file its looking at is only a date field?
4 Replies
v-lili6-msftCommunity Support
hi elenton
I have tested on my side, it works well.
Just click AM/PM then it will change.
If you could update the power bi desktop to lastest version and try it again.
https://www.microsoft.com/en-us/download/details.aspx?id=58494
Regards,
Lin
elentonv-lili6-msft just tested in desktop and it works fine, its the online deployed version i have the issue with. I will try deploying the desktop version again see if there was an issue in the desktop version when i deployed it.
- v-lili6-msft