Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

mattt

Advanced Filter Issue

Submitted by on ‎12-27-2017 02:39 PM

On Power BI web version - I am having an issue when advanced filtering for a range of dates between two dates.  E.g. 

First filter = On or After 1 January 2017

Second Filter = On or Before 31 December 2017

 

When I use the calendar to select 1 January in my first filter, it populates 1 January 2017 in my second filter.  I can manually type the date in to get the correct date in my first filter but normally I prefer to use calendat view when selecting dates.

 

PowerBI team please look into.

 

Thanks!

Matt

Status: Accepted
See more ideas labeled with:
6 Comments (6 New)
Comments
adamgtaylor
Regular Visitor
‎12-27-2017 03:05 PM

Having this issue as well.

 

There's a workaround we've found until this gets resolved:
1) Set the first filter on or after and select the date from the calendar
  Note that the date will not fill in here

2) Select "And" and select is on or after
  The date from above will be filled in here

3) Click apply filter
  This will fill in the upper filter with the correct date
4) Select on or before in the second filter, and select the date, then click apply

  You'll now have the correct date filters in both

 

For whatever reason, the date doesn't get filled in the top filter until after you apply it in the second filter (step 2 and 3).

Gerard_R
Advocate I
Advocate I
‎12-27-2017 08:45 PM

Also having the same issue with the first panel of the Advanced Filter when trying to select a date.  We've published our reports using November 2017 Power BI Desktop (or earlier) and running both 32 Bit and 64 Bit versions. We are using PowerBI Pro licenses and On Premises Gateway.

Same issue occurs when using the Advanced Filter on our iPad Pro.

Thanks Permalink for the work around details.  Looking forward to a speedy fix.

v-qiuyu-msft
Community Support
Community Support
‎12-28-2017 12:00 AM

Hi all,

 

The issue has been reported before internally: CRI 54793685. 

 

This issue will be fixed in the early January 2018.

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎12-28-2017 12:01 AM
Status changed to: Accepted
 
neilp1
Frequent Visitor
‎01-09-2018 06:01 AM

Was the fix supposed to be released with todays January update?

 

I'm still seeing this bug.

 

This is making life difficult for us as our user expereince very much relies on the use of the date filter.

bendenison
Frequent Visitor
‎01-17-2018 01:33 AM

Also still having this issue.

 

Another work around is to manually type in the first date "On or after" then pick the second.

 

Not ideal as unexpected behaviour for users.

 

Any update please?

Idea Statuses