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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bendenison
Frequent Visitor

advanced date picker strange behaviour

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

4 REPLIES 4
LeeWelch
New Member

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

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

 

 

Hi @bendenison,

What error did you get?

Best Regards,
Angelia

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.