Forum Discussion
Time format changes
Hello,
I have a calculated colum with the follwing formula:
TimeStamp EST = CALCULATE(MAX(TABLENAME[TIME_EST]),
FILTER(TABLENAME,TABLENAME[COL1]
= EARLIEST(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
3 Replies
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
If possible please share a sample pbix file after removing sensitive information.Thanks.
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
