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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
FilipK
Resolver I
Resolver I

Date format change, time information lost in PBI Desktop

I've got a very odd behaviour, I can't explain myself. Hope you can.

 

I loaded table visual where one column includes the timestamp. 

The format I chose is 

FilipK_1-1625050367369.png

When configuring the visual for the first time everything looks good.

FilipK_2-1625050493968.png

After closing it and open it again on another PC it looks this way.

FilipK_0-1625050332848.png

Can you explain how this could happen? 

I thought about the regional settings - perhaps it is due to the fact that the other PC has German setting while the other is setup as Englisch. Anyway it could be acceptable if the time isn't get lost at all.

 

Just by changing the timeformat to another and back to initial one the time appears again. You can imagine that if you work simulteanously in a team with different configuration this workaround cannot be the solution for there are more than ten different timestamps effected in the report

4 REPLIES 4
mahoneypat
Microsoft Employee
Microsoft Employee

You should be able to use a custom format string for your column or measure, so it is not impacted by the computer locale.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs

 

Pat

 





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

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi @mahoneypat , 

 

the custom format didn't work. My colleague adapted all timestamps to custom format and saved the pbix.

Once I open it, the timestamps are not the same anymore (yyyy-MM-dd HH:mm instead yyyy-MM-dd HH:nn). Our regional settings are as follows:

 

Colleagues PC:

FilipK_0-1625122226742.pngFilipK_1-1625122249622.png

My PC: 

The same.

Hi Pat @mahoneypat .

Thanks for fast feedback. I'll try and let you know if that fix my issue. Can you explain why computer locale could lead to a complete loss of the time? I can't imagine there is region in the world where the time information is not neccessary.

 

BR

In Power BI, Dates always have a time component (midnight for just Dates) and times always have a date component (12/31/1899 for just times), it is just a question of if it is displayed or not.

 

Pat

 





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

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.