Forum Discussion
Changing Dim_date from regional settings to us
That PQ function does not convert a date in a column from one type to another. (It exists to allow PQ to properly interpret a date that is presented in a format different from your local computer settings).
If you do not want to add a new column, but you still want to see dates (as actual dates and not as text representations), another option is to change your Windows Regional Settings to reflect the desired locale (US-English in this case).
You may also be able to change the locale of the file in Power BI options, but I have not tested that method.
Hi,
sorry didnt work.
Still automatically this is converted into polish ones:
how to keep this regional setting while sharing report with bpip format?
Best,
Jacek
Power BI does not embed strict, enforced locale metadata in .pbix or .pbip files that overrides the viewer’s regional settings in Power BI Service or Power BI Desktop on a different machine.
So If you send the .pbix to someone in the US, Power BI may render visuals (like date formats) using their system or Power BI regional settings — which is usually what you want.
For the earlier one you tried, you can refer to this link from SQLBI.
Changing the culture of a Power BI Desktop file - SQLBI
or you still worry you can hard-code formatting using Calculated column.
Date_Formatted = FORMAT('Dim_Date'[Date], "MM/DD/YYYY")