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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Justas4478
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors