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: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

0

Advanced filtering date US format

Submitted by Anonymous on ‎10-10-2022 02:26 AM

When filtering a report the format of the Date is UK- but the advanced filtering is in US format.

 

date.jpg

Status: Delivered
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎10-10-2022 02:29 AM

It seems to be the same as this issue which was previously resolved - https://community.powerbi.com/t5/Issues/Problems-with-Advanced-filter-for-dates/idi-p/1075912

Anonymous
Not applicable
‎10-11-2022 12:28 AM

Hi @Anonymous ,

 

We have reported your issue and have submitted to internal icm 340889622 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

 

Best Regards,
Community Support Team _ Caitlyn

 

Anonymous
Not applicable
‎11-04-2022 01:44 AM

Hi,

Has there been any progress on this?

Kind regards,

Mary

Anonymous
Not applicable
‎11-04-2022 02:30 AM

Hi @Anonymous ,

 

We got the feedback from PG team:

"Verified with PM this is intentional. The filter restatement is showing a formatted field value. The date control in filter pane is working in the user's locale."

 

Please set it in Power BI Desktop > options and settings > locale for import .

vcaitlynmstf_0-1667554204945.pngvcaitlynmstf_1-1667554216177.png

 

Best Regards,
Community Support Team _ Caitlyn

 

Idea Statuses