Forum Discussion
Date in data problem
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 ...
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").
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.