Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |