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

%3CLINGO-SUB%20id%3D%22lingo-sub-1947619%22%20slang%3D%22en-US%22%3EGannt%20tooltip%20shows%20UK%20dates%20in%20app.powerbi.com%20but%20US%20dates%20in%20modern%20sharepoint%20webpart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947619%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20subject%20suggests%2C%20UK%20dates%20(dd%2Fmm%2Fyyyy)%20showing%20as%20I%20want%20on%20the%20PowerBI%20desktop%20and%20PowerBI%20online%20version%20of%20my%20gannt%20chart%20tooltip.%20However%2C%20when%20I%20add%20the%20report%20to%20SharePoint%20webpart%20the%20tooltip%20becomes%20US%20dates%20(mm%2Fdd%2Fyyyy).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Regional%20Locale%20on%20my%20SharePoint%20site%20is%20set%20to%20UK%20so%20that%20shouldn't%20be%20the%20issue.%20Anyone%20enountered%20this%20and%20got%20a%20solution%20or%20workaround%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EOn%20PowerBI%20online%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-11-25%2010_12_00-Project%20Tracker%20-%20Power%20BI.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237249iC6A63469441B36A6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222020-11-25%2010_12_00-Project%20Tracker%20-%20Power%20BI.png%22%20alt%3D%222020-11-25%2010_12_00-Project%20Tracker%20-%20Power%20BI.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3Evs%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EOn%20SharePoint%20webpage%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-11-25%2010_13_31-Technology%20and%20Infrastructure%20Project%20Reporting.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237250iBE201519B5152E55%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222020-11-25%2010_13_31-Technology%20and%20Infrastructure%20Project%20Reporting.png%22%20alt%3D%222020-11-25%2010_13_31-Technology%20and%20Infrastructure%20Project%20Reporting.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%3ESharePoint%20locale%20settings%20for%20the%20site%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-11-25%2009_56_48-Regional%20Settings.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237251i5EAC794DD1F8889F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222020-11-25%2009_56_48-Regional%20Settings.png%22%20alt%3D%222020-11-25%2009_56_48-Regional%20Settings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ELocal%20computer%20regional%20settings%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-11-25%2010_15_02-Settings.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237252i08E2E12E2078A2A2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222020-11-25%2010_15_02-Settings.png%22%20alt%3D%222020-11-25%2010_15_02-Settings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1947619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EModern%20SharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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:

 

2020-11-25 10_12_00-Project Tracker - Power BI.png

 

vs

On SharePoint webpage:

 

2020-11-25 10_13_31-Technology and Infrastructure Project Reporting.png

SharePoint locale settings for the site:

 

2020-11-25 09_56_48-Regional Settings.png

Local computer regional settings:

 

2020-11-25 10_15_02-Settings.png

 

0 Replies