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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
coatsy35
Helper II
Helper II

Some users see US date format

Hi all,

 

I have a multiple pbix's that are published to our service fine. However some users see the date format in US format instead of UK format. I can't figure out why this is. The pbix has it's region set to UK. Their windows enviroment is all configured for UK region and English UK language on all users PC's. Their browser language is configured to UK and English UK. There are no US settings anywhere. Most users see it with UK date format. I'm assuming this is a O365 setting for the user somewhere thats not correct.  

 

How do I change this as office admin? It must be a tennant setting somewhere. As if I log into his Power BI service on my PC through the same browser I use, he has US dates and my copy has UK dates - so defintiely AD or PowerBI service setting. Is there a way I can check all users and globally change? we only work in the UK

 

Any help greatfully received. 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @coatsy35 ,

 

For all Microsoft 365 services (including OneDrive For Business, Delve, and SharePoint Online), you can change the language and regional settings at the user level in a Cloud identity or Synchronized identity model by using Microsoft Graph PowerShell.

For more details, please refer: Set language and regional settings for Microsoft 365 - Microsoft 365 | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

View solution in original post

6 REPLIES 6
coatsy35
Helper II
Helper II

Fast forward 6 months and still finding this dispute my efforts. Why can the pbix not keep it UK style if it was created that way? I've just given out a new dashboard today and half the users are reporting the date slicers are in US format, dispute the data hosted in the UK and me designing it with UK date format. Any other suggestions? On the users in question their windows languages UK English, their browser is in UK English and as said we have it hosted on UK London, so why are they seeing US date formats? There office account is also set to UK english

Anonymous
Not applicable

Hi @coatsy35 ,

 

First of all thanks to @bhanu_gautam  for the quick reply. I would like to make some additions:

As a global administrator of PBI, you can check the Power BI Service settings for the affected user:

Starting inside the Power BI service (app.powerbi.com)

1) Click on the gear icon in the top right corner

2) Click on Settings

3) Select Language

4) Select Default Browser Language

5) Go to your browser settings and set English as your browser's default language.

 

For more details, please refer: Solved: Date displayed in american format - Microsoft Fabric Community

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

That is already set. It turns out it is due to certain users having thei display language and region format set to US int he ir office account. Non of them even knew where the setting was, so I assuem it was done 8-9 years ago when we first went with O365. These are peopel who are not technically minded. I can't check all acocutns as I can't see a way to do so.

Anonymous
Not applicable

Hi @coatsy35 ,

 

For all Microsoft 365 services (including OneDrive For Business, Delve, and SharePoint Online), you can change the language and regional settings at the user level in a Cloud identity or Synchronized identity model by using Microsoft Graph PowerShell.

For more details, please refer: Set language and regional settings for Microsoft 365 - Microsoft 365 | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

bhanu_gautam
Super User
Super User

@coatsy35 Hi the reason might be ;- Power BI service operates in the UTC time zone, and evaluates all locale based time functions in that time zone. Power BI Desktop evaluates them according to the locale of the user.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






That may be, but not sure how. As I canot log into two different PB service accounts on my PC and have different date formats shown in both. It's to do with the user acocunt screen language and region format. Howver the only way I can see to change this is to do it for each user individually. Hopign their is a way to change them all through O365 admin

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.