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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sharksguts
Frequent Visitor

Format Date and Time

When you add the Power BI report as a tab in Microsoft Teams the date format is shown as US format mm/dd/yyyy.

 

The date format is fine in Power BI desktop and on the Power BI (browser) as long as you set the right language in your browser.

 

However the Android mobile app and Teams desktop app still show the wrong format.

 

 

I have searched the forums but have only found a bug in the past that they say is now fixed.

 

The date format is in a slicer and a card to show when it was last refreshed.

 

image.png

 

I have set the region on the user setting in microsoft teams.

image.png

6 REPLIES 6
marcopol
Advocate I
Advocate I

Why can't Microsoft make products that handle different date formats? There's always a problem with dates either timezones or formats.

PROLIFEFOODS
Regular Visitor

Still having this issue, Desktop, Web Browsers are showing DD/MM/YYYY but the report when added as a tab in MS Teams is showing MM/DD/YYYY

nickdewitt
Frequent Visitor

Any updates to this? I am having the same Issue, only when adding a power bi report to teams.

v-shex-msft
Community Support
Community Support

HI @Sharksguts,

 

AFAIK, these datetime format is based on device setting , maybe you can try to modify language and region settings on your android device and try again.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Both on android phone and windows 7 PC browser I believe I have set the language and region correctly but still shows the date in the wrong format. I have even tried IE as well as firefox and chrome.

 

image.png

 

image.png

Have found part of the solution from this https://superfarb.com/power-bi-customising-date-format/

 

Change the language to defualt (browser language) and the date format displays correctly in all browsers as long as you have set the browser language correctly.

 

So the browser now shows the format correctly however Teams and Android App still don't, Is there a place the language is set for these that I am missing?

 

image.png

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors