topic Re: Power Query date conversion not working even after using "Chnage Type with locale (english-India) in DAX Commands and Tips

Power Query date conversion not working even after using "Chnage Type with locale (english-India)

Karthagurunadam — Thu, 30 Oct 2025 17:05:50 GMT

My sales date Column shows dates like 14/04/2017, but even after using Transorm-Data type-Using locale-English(india). The dates are not converting correctly (still showing US format).

Re: Power Query date conversion not working even after using "Chnage Type with locale (english-India)

lbendlin — Thu, 30 Oct 2025 23:27:26 GMT

There's no such locale. Use "in-IN" or "en-GB"

Re: Power Query date conversion not working even after using "Chnage Type with locale (english-India)

v-veshwara-msft — Mon, 03 Nov 2025 12:27:42 GMT

Hi Karthagurunadam ,

Thanks for reaching out to Microsoft Fabric Community.

Power BI displays date values based on the Windows regional settings, even if you change the locale within Power BI Desktop.

If you need the dates to appear in Indian format (dd/MM/yyyy), you can create a custom column in Power Query using: Date.ToText([Sales_Date], "dd/MM/yyyy") and use that column in your visuals.

A similar behavior has been discussed in community thread such as Solved: Changing date format that won't change with region... - Microsoft Fabric Community and is also mentioned in Microsoft’s supported languages and regions documentation , which notes that Power BI derives its default format from the Windows regional settings.

Hope this helps. Please reach out for further assistance.

Thank you.

Re: Power Query date conversion not working even after using "Chnage Type with locale (english-India)

v-veshwara-msft — Fri, 07 Nov 2025 04:52:28 GMT

Hi Karthagurunadam ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

Re: Power Query date conversion not working even after using "Chnage Type with locale (english-India)

v-veshwara-msft — Tue, 11 Nov 2025 04:28:37 GMT

Hi Karthagurunadam ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.