Relative Date Filtering Incorrectly

[powerbi_user_]

Relative date filter / slicer display does not match generated DAX Query filter. 

I would not expect to see "2/28/2022" when the visual is filtered to "3/1/2022 - 4/28/2022".

Per the performance analyzer, it looks like the visual is internally filtering to >= 2/28/2022, but displaying a filter of >=3/1/2022.

// DAX Query
DEFINE
VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('Date'[Date])),
AND('Date'[Date] >= DATE(2022, 2, 28), 'Date'[Date] < DATE(2022, 4, 29))
)

VAR __DS0Core =
CALCULATETABLE(
DISTINCT('Date'[Date]),
KEEPFILTERS(__DS0FilterTable)
)

VAR __DS0PrimaryWindowed =
TOPN(501, __DS0Core, 'Date'[Date], 1)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'Date'[Date]

 Am I missing something? Is this actually expected behavior?

Thanks.

Power BI Desktop, Version: 2.104.702.0 64-bit (April 2022)

[v-cazheng-msft]

Hi @powerbi_user_ ,

I can repro this issue and have reported it internally(ICM 304812788). Will sync here once there is any update. Thanks for your understanding!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @powerbi_user_ ,

Here is a newly released Power BI Desktop:Download Microsoft Power BI Desktop from Official Microsoft Download Center. Based on the test, this issue should not happen in it. Could you please try with it and confirm whether this issue still exists? If it still happens, please let me know the repro steps or provide a download link of a sample PBIX file so the product group members can investigate on it. 

Also, please let me know the Regional settings of your Power BI Desktop. 

In addition, please check whether this issue is happening in Power BI service as well. 

Thank you very much!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @powerbi_user_, 

May I know whether this issue sitll exist? If there is nothing wrong with it, I will change the status of this post to Delivered in two days. Thanks for your understanding!

Best Regards,

Community Support Team _ Caiyun