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: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0
NoMoreFaith

Table View filtering BETWEEN dates is operating "On or after" as "after"

Submitted by on ‎07-26-2022 07:31 AM

Hi,


Come across this issue troubleshooting some figures.  In Power BI Desktop, Table View -> Filtering a dataset using the parameters for filtering dates BETWEEN, the option "On or after" is operating as "after".  

Example: the filtered rows for the date period between on or after 01/06/2022 and on or before 30/06/2022 is identical to the filtered rows for after 01/06/2022 and on or before 30/06/2022.
Data contains 4436 rows on the 01/06/2022 but does not change from on or after and just after.

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎07-26-2022 07:54 PM

Hi @NoMoreFaith 

It's a known issue . The ID of ICM is 319032422 . You can first filter the date through the filter in the visual. PG will fix it and roll it out soon. Please wait patiently .  

Here is a similar case .

https://community.powerbi.com/t5/Issues/We-are-having-an-issue-with-the-Date-column-across-many-repo... 

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses