cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CloudMonkey
Post Prodigy
Post Prodigy

Service user seeing report date/times in other country format

Hi

 

One of my users is seeing dates and times in another country's format - please can you tell me how to fix? She is seeing:

01/28/2021 instead of 28/01/2021

12:00am instead of 00:00am

 

Thanks!

 

CM

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @CloudMonkey 

Power BI Service will display the format of date/time according to the Timezone related with the settings of language. So it will be affected by the following settings.

 

1 Settings>General>Language in Power BI Service

v-cazheng-msft_0-1617267717049.png

 

 

v-cazheng-msft_6-1617267767816.png

 

 

2 If the Language of the user in Power BI Settings is set as Default(browser language), then the date format will be affected by the Language of the user's browser. Take Microsoft Edge as an example, Settings>Language>Preferred languages.

v-cazheng-msft_2-1617267717076.png

 

 

Here is a test.

1 The language of the pbix is English and the date format is as following.

v-cazheng-msft_3-1617267717079.png

 

2 If the language of Service is set as Chinese, then the date format will look like this.

v-cazheng-msft_4-1617267717079.png

 

3 After changing the language to English, the date format will change as following.

v-cazheng-msft_5-1617267717080.png

 

For more details, you can refer How to change the date Format in the Power BI Service.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? 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

3 REPLIES 3
v-cazheng-msft
Community Support
Community Support

Hi @CloudMonkey 

Power BI Service will display the format of date/time according to the Timezone related with the settings of language. So it will be affected by the following settings.

 

1 Settings>General>Language in Power BI Service

v-cazheng-msft_0-1617267717049.png

 

 

v-cazheng-msft_6-1617267767816.png

 

 

2 If the Language of the user in Power BI Settings is set as Default(browser language), then the date format will be affected by the Language of the user's browser. Take Microsoft Edge as an example, Settings>Language>Preferred languages.

v-cazheng-msft_2-1617267717076.png

 

 

Here is a test.

1 The language of the pbix is English and the date format is as following.

v-cazheng-msft_3-1617267717079.png

 

2 If the language of Service is set as Chinese, then the date format will look like this.

v-cazheng-msft_4-1617267717079.png

 

3 After changing the language to English, the date format will change as following.

v-cazheng-msft_5-1617267717080.png

 

For more details, you can refer How to change the date Format in the Power BI Service.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? 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

HarishKM
Responsive Resident
Responsive Resident

@CloudMonkey  Hey Mate ,
Kindly enable this setting and republish .

HarishKM_0-1617164187193.png

and 2nd option :

HarishKM_1-1617165101687.png
Try this , It will work .

 

lbendlin
Super User III
Super User III

she needs to change the locale settings on her PC.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.