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
Justas4478
Post Patron
Post Patron

Date displayed in american format

I have reports published in the multiple workspaces and for everyone dates are displayed in UK date format like it should. But for one employee one one of the reports only date are displayed in American format. I attached screenshots showing how everyone sees them circled green and how that one employee sees them circled red. Does anyone know what could be the problem. We did try checking regional and time setting in the laptop but that didnt help. I have no idea what could be causing the changes to only one person. 

Correct date format.PNGWrong date format.PNG

1 ACCEPTED SOLUTION
Justas4478
Post Patron
Post Patron

This solution offered by support staff helped me to solve the problem. The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser.  In this case, we are going to use chrome for the example.

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

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

2) Click on Settings

Justas4478_0-1629273616374.png

 

 

3) Select Language

4) Select Default Browser Language

Justas4478_1-1629273616375.png

 

5) Go to the Browser Settings

Justas4478_2-1629273616376.png

 

6) Search browser setting for “Language”

Justas4478_3-1629273616378.png

 

7) If your correct language/region is not shown select add language

Justas4478_4-1629273616379.png

 

😎 Select the 8 vertical dots next to the language you want to be the primary language

Justas4478_5-1629273616380.png

 

9) Choose Display Google Chrome in this Language

Justas4478_6-1629273616380.png

 

10) Go back to Power BI and refresh your report/dashboard

View solution in original post

5 REPLIES 5
Justas4478
Post Patron
Post Patron

This solution offered by support staff helped me to solve the problem. The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser.  In this case, we are going to use chrome for the example.

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

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

2) Click on Settings

Justas4478_0-1629273616374.png

 

 

3) Select Language

4) Select Default Browser Language

Justas4478_1-1629273616375.png

 

5) Go to the Browser Settings

Justas4478_2-1629273616376.png

 

6) Search browser setting for “Language”

Justas4478_3-1629273616378.png

 

7) If your correct language/region is not shown select add language

Justas4478_4-1629273616379.png

 

😎 Select the 8 vertical dots next to the language you want to be the primary language

Justas4478_5-1629273616380.png

 

9) Choose Display Google Chrome in this Language

Justas4478_6-1629273616380.png

 

10) Go back to Power BI and refresh your report/dashboard

Anand24
Super User
Super User

Hi @Justas4478 ,
1. Check the regional settings of that user's system and be sure it is set to UK

2. Try hard-coding the format to "DD-MM-YYYY" and then use in slicer

3. Tell the user to open the report in incognito mode just to make sure no nrowser cache is creating issue

 

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

Incognito mode didnt help as well. Still geting american date format.

@Justas4478 ,
If this is specifically happening for just 1 user and you have checked everything from my previous reply, you can raise an MS Support ticket and get dedicated help. Link

 

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

I did try already Regional settings all is good there. As for hard-coding the date I cant do that since I am using live connection cube for the report and only can use measures. I will try the incognito mode to see if that changes anything.

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.

Top Solution Authors
Top Kudoed Authors