Time format changes

[sabeensp]

Hello,

I have a calculated colum with the follwing formula:

TimeStamp EST = CALCULATE(MAX(TABLENAME[TIME_EST]),

FILTER(TABLENAME,TABLENAME[COL1]
= EARLIEST(TABLENAME[COL1])))

It show data in correct format as shown below.

But when I bring the above field to grid visual entire format changes, see below

Please help. Thanks

[Anonymous]

@sabeensp 

It seems you have the the correct data/time data type, if you just drag the column into a table or matrix visual, the format should remain the same.

Best regards
Paul Zheng

[amitchandak]

 If possible please share a sample pbix file after removing sensitive information.Thanks.

[Greg_Deckler]

By grid visual, are you referring to a Table visualization or Matrix or ?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490