Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
lc_finance
Solution Sage
Solution Sage

Hi @Anonymous ,

 

 

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

Anonymous
Not applicable

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 

Hi @Anonymous ,

 

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.