US date and UK date format

tracy2020 

Go to File --> Options and Settings --> Options --> Current File --> Regional Settings

and in the locale for import either choose UK or US.

I think it is UK in your case, if your underlying locale and how you want to see the the dates in the report is US, but I haven't completely understood. So try with both

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hi tracy2020 ,

I may not be fully understanding your problem correctly, but a common issue I've found with SharePoint and Power BI is when the region of the SharePoint library has not been correctly set. It often defaults to US.

In SharePoint, if you go to  'Settings' --> 'Site Information' --> 'View all site settings' --> 'Regional Settings'

you should be able to check/update if this is the issue.