Date in data problem

[ChristianE]

Hi all

My date settings are "ddmmyyyy", but for some reason whenever im trying to filter a datacolumn (using the option date "filters -> After ") that specific menu is "mmddyyyy"

Is there any way to change this or is it a bug?

[az38]

Hi @ChristianE 

there is a difference between format that data dispalyed to user and locale date format

as I understand you set displayed format (possible in Modelling ribbon) as "ddmmyyyy", but its still "mmddyyyy" format as your system localization. So, built-in filter uses system format 

anyway try to change language in File-Options-Regional Settings

do not hesitate to give a kudo to useful posts and mark solutions as solution

[ChristianE]

Hi @az38 

I haven't changed any settings, they are at "Danish" (which uses "ddmmyyyy"), and it works fine everywhere except when i try to filter a table under the "data" panel (where it only accepts "mmddyyyy").

[v-juanli-msft]

Hi @ChristianE 

As tested with this kind of setting, 

My server->Setting->Time&Language

Power BI->Files->Options and Setting->Regional Settings

The format of date column is correct in both data model view and power query view filter.

Please check your setting, if you have any probelm, feel free to let me know.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.