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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
johnnr892
Regular Visitor

Gannt tooltip shows UK dates in app.powerbi.com but US dates in modern sharepoint webpart

As subject suggests, UK dates (dd/mm/yyyy) showing as I want on the PowerBI desktop and PowerBI online version of my gannt chart tooltip. However, when I add the report to SharePoint webpart the tooltip becomes US dates (mm/dd/yyyy).

 

My Regional Locale on my SharePoint site is set to UK so that shouldn't be the issue. Anyone enountered this and got a solution or workaround?

 

On PowerBI online:

johnnr892_0-1606299140365.png

vs

On SharePoint webpage:

johnnr892_1-1606299231039.png

SharePoint locale settings for the site:

johnnr892_2-1606299280576.png

Local computer regional settings:

johnnr892_3-1606299319146.png

 

 

5 REPLIES 5
v-kelly-msft
Community Support
Community Support

Hi @johnnr892 ,

 

Could you pls try to open the sharepoint site in incognito mode?I'm afraid it's a cache issue.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Still no luck - still American date format with the following:

  1. A colleague who has access sees American date format
  2. Incognito is also American date format
  3. I cleared my cache and still American date

 

Hi @johnnr892 ,

 

Below is a blog about how to change the American format in Sharepoint,hope this would help.

https://sharepointmaven.com/change-date-format-sharepoint/

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

 

Hi Kelly, sorry if the picture is small in my original post, but I've already checked this and the SharePoint locale is correct. Please see my original post

Hi @johnnr892 ,

 

Since it's a sharepoint issue,I'd like to suggest you go to Office 365 forum to get better support.You can close or delete the forum from Power BI then create a new one in Office 365  forum.

Much appreciated.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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