Forum Discussion
Post Partisantimestamp custom format for milliseconds not working
Hi dpombal ,
Create a duplicate column(TradeTimestamp-copy) in power query and convert it into Text.
Then in Table visual ,use the TradeTimestamp-copy for table visual.For sorting TradeTimestamp-copy column use original TradeTimestamp column.
Please give Kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Super User
Power BI's default Date/Time formatting does not support milliseconds (fff) in the visual formatting pane. To display milliseconds, you need to convert the datetime to text with milliseconds included.
DateTime.ToText([TradeTimestamp], "dd/MM/yyyy HH:mm:ss.fff", "en-US")
Then use this new text column in your report visuals.
If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
Post PartisanWhen will this be fixed? model size is huge to duplicate columns