Date format in report view appears in MM-DD-YYYY but in model and table view is DD-MM-YYYY

[pmmarinou]

Hello,

I set the date in model view to be in the desired format of DD-MM-YYYY.

However, in the report view it appears in MM-DD-YYYY format.

Any ideas how to correct this? I did a lot of research and all of the suggestions failed.

Thank you

[rajendraongole1 · Accepted solution]

Hi @pmmarinou - Check the "Locale for import" setting. Ensure it is set to a region that uses the DD-MM-YYYY format, such as "English (United States)" or any other appropriate region.You can change this to your desired region, and it should apply to all the data imported.

check on regional settings, locale settings in Power BI Desktop, or specific format settings applied to visuals.

Hope it works

[Anonymous · Accepted solution]

Hi @pmmarinou ,

When you use a slicer to display or set a range of dates, the dates display in the Short Date format. The user's browser or operating system locale determines the date format. As such, it will be the display format no matter what the data type settings are for the underlying data or model.

Create a numeric or date range slicer in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1 · Accepted solution]

Hi @pmmarinou - Check the "Locale for import" setting. Ensure it is set to a region that uses the DD-MM-YYYY format, such as "English (United States)" or any other appropriate region.You can change this to your desired region, and it should apply to all the data imported.

check on regional settings, locale settings in Power BI Desktop, or specific format settings applied to visuals.

Hope it works

[pmmarinou]

This didn't work in my case. Thank you for your reply!

[uzuntasgokberk]

Hello @pmmarinou,

You can solve this problem in your Power Query Side. I've made an example for that. Firsty, I have date such like MM/DD/YYYY and when I change type only to date. In visualization side won't be changing. But İf you change type as with Locale and for example made Locale as Turkish. İt will be dd/mm/yyyy type. And when ı close&apply. it will be what you would like to see.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[pmmarinou]

This didn't work in my case. Thank you for your reply!