advanced date picker strange behaviour

[bendenison]

Hello,

I am having an issue with the date picker advnaced search on power bi online.

I am using the Advanced filter option in Power Bi Online on a date field. It has been working fine until this month. I am using On or after and On or before as the date criteria. It is as if the On or after filter is enabled but locked, so the user can drop the date picker, select a date, but the date doesn’t change in the On or after filed, it actually updates the On or before date!

This is the same when going into Edit Report mode. All the other filters seem to work. Power Bi desktop also works ok.

The work around is to manually type the date into the field which works in the most part. But this is obviously not ideal, as the behaviour is confusing to say the least to users.

Any urgent help much appreciated.

Ben

[LeeWelch]

Hi Ben,

I don't have a resolution for this, but I'm experiencing the same behaviour.

The first date picker (on or after) doesn't allow any selections via the calendar control whereas the second (on or before) does, manually entering the date works but is a pain.

Looking for a resolution as well.

Lee

[bendenison]

It looks like this is expected to be resolved, but isnt resolved for us yet:

https://community.powerbi.com/t5/Issues/Advanced-Filter-Issue/idi-p/329717

[v-huizhn-msft]

Hi @bendenison,

What error did you get?

Best Regards,
Angelia

[bendenison]

No error message as such, just the date pickers containing the incorrect date.