Forum Discussion
Date Format in Data View differs from Report View
Hi Florimond,
If your dates look correct in the Data View (DD/MM/YYYY) but flip to the US format (MM/DD/YYYY) in Report View or the Power BI Service, you are likely dealing with a conflict between "Regional Settings" and "Explicit Formatting."
The best way I would say to fix this is to hard-code the format for the column -
-
Select the Date Column in your field list.
-
In the Column Tools ribbon at the top, look for the Format section.
-
Do not just select "Short Date." Instead, click the dropdown and manually select or type:
dd/MM/yyyy.
If the report looks correct in Desktop but wrong in the browser, the user's browser language is likely set to English (United States).
-
Go to the Power BI Service > Settings (Gear Icon) > General > Language.
-
Ensure it is set to "Defined by browser" and verify that the browser has the correct language at the top of the list.
Let me know if this helps!