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.
thank you,
i do not want to add new column if i am creating source Dim_Date table outside power bi.
I want to just import table and see visuals in proper language which i set up.
I tried to convert Date column using Local settings in power query but it is not working. Still shows Date column as polish one even i have this step added:
= Table.TransformColumnTypes(DateColumn, {{"Date", type date}}, "en-US")
This is possible at all?
Best,
Jacek
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.