cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Regional Date Formats Display

Hi Everyone,

 

I hope someone can help me with this.

 

I have built a report in Power BI and have the dates showing for when some opportunities are due to complete. I have now deployed the reports and the guys in the USA are asking if the date formats can be shown in mm/dd/yyyy. I am in the UK and the UK users want it in dd/mm/yyyy. I can't seem to find anything that helps me get the report to use the local settings of the user.

 

Can anyone help we on this?

 

Thanks

Paul

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Regional Date Formats Display

Hi @PaulThurlow ,

 

 

If you are ok doing it with DAX, you can use FORMAT to fix it.

For example FORMAT('Table'[Date], "dd-mm-yyyy")

 

Does this help you?

 

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

Highlighted
New Member

Re: Regional Date Formats Display

Hi @lc_finance

 

I need the format to be different depending on where the user is based. US users to see mm/dd/yyyy and UK users to see dd/mm/yyyy.

 

Ideally it picking up from the users regional settings on their device.

 

Thanks

Paul 

Highlighted
Super User II
Super User II

Re: Regional Date Formats Display

Hi @PaulThurlow ,

 

 

they should be able to change by going on File -> Options and settings ->  Options -> Regional Settings.

 

Let me know if that works

 

LC

 

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors