Date formatting to US in PowerBI - Query shows UK

[ApexLG]

So my data is imported into PowerBI as text (Date in excel) - when I try to convert this into Data to create measures from, it changes to US formatting (MM/DD/YYYY) I edited the query and changed type to Date, and edited locale to UK formatting. This shows fine in the query editor, but as soon as I close and apply its still text? It then goes to US formatting again when trying to change the type. Is this a bug or am I doing something wrong? I'm editing an Append of 4 sets of data, and each set has the column set up as a date format.  

 

 

 

 

[ApexLG · Accepted solution]

The only way I resolved this was to delete my Append and create a new one. It seemed some dates were in US format and others UK - so the ones which were the US format (01/29/25) appeared to make everything else change. When creating a new Append everything showed how it should!

[FBergamaschi]

Have you checked that there are not steps after the one you showed that override your changes?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[ApexLG]

@FBergamaschi I made sure to have my locale change at the end of the applied steps - it doesnt seem to carry the formatting change over to PowerBI. 

 

[FBergamaschi]

Checking again your post

Are we sure it is not just a matter of format?

I mean, have you checked the format in Power BI Desktop? Maybe changing that you will find what you are looking for, it seems to me rechecking the post it is only a matter of format

see below picture

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[ApexLG]

@FBergamaschi I don't think its formatting.

The date is 01/09/2025 (1st Sept), correct, but in text form. When I change this to date format it changes to 09/01/2025 (9th Jan) which of course isn't right. In query editor the data type is Date and is exactly what I want, but when closing and applying PoweBI still shows it as Text which I can't get around!

[FBergamaschi]

Can you send me the pbix so I can check the issue? You should also send me the source files

Without putting my hands on it, I can't understand what the hell is happening

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI