Nalsey's avatar
Nalsey
Regular Visitor
3 years ago
Status:
Done

Published report converts date to US format

I use dd/mm/yyyy format on PBI desktop, but when published to online, that date is converted to US format mm/dd/yyyy.   This has only just happened in the last week or so. Worked fine for months pr...
Reports
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago
Status changed:
New
to
Investigating

Hi Nalsey ,

Try the following steps to remedy that.

  • Open your PBIX file > Go to Transform Editor (Power Query Editor)
  • Select the Date Column > Right Click on Column Name> Change Type > Using Locale

  • Once you click on Using Locale, a window pops-up with the below options

  • Change Data Type to Date or DateTime and Locale to your desired locale type
  • And click on OK and apply the transformations and publish to service

Best regards,

Community Support Team_yanjiang

Completed Ideas