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 jaryszek ,
As correctly said by MasonMA and ronrsnfld , Power BI does not embed fixed regional settings in .pbip or .pbix files. Visuals always reflect the viewer’s regional format, which is why the date reverts to Polish when opened locally.
To ensure your date always appears in MM/dd/yyyy format regardless of region, the best solution is to convert it to a text column using one of the following:
for Dax use the following :
US Date = FORMAT('Dim_Date'[Date], "MM/dd/yyyy", "en-US")
In power query M:
Table.AddColumn(#"Previous Step", "US Date", each Date.ToText([Date], [Format="MM/dd/yyyy", Culture="en-US"]))
Thank you ronrsnfld and MasonMA for providing the information. Hope this help you out resolving your issue.
Please feel free to contact us if you have any further questions. If the response has addressed your query, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.