Forum Discussion
Super UserChanging 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 ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
To make sure Power BI always displays dates in the US format (MM/DD/YYYY), use a locale-specific conversion in Power Query. Right-click your date column, choose Change Type → Using Locale, pick Date as the type, and set the locale to English (United States). This ensures dates are interpreted and shown correctly, no matter your system or default Power BI settings. You can also adjust the file-level locale under File → Options → Regional Settings by selecting English (United States) to keep visuals consistent. These steps should prevent the date format from changing unexpectedly.
Please refer the below image for your undersatanding
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.