Forum Discussion
Time format [h:mm tt]
I have a text field which contains value in the form of: 10:30:00 14:00:00 When I tell that this field contains time value and apply the time format [h:mm tt] the result is 10:30 tt 14:...
For the life of me, I cannot recreate this. Are you on the January update and are there any regional language settings involved?
I'm using the latest Power BI desktop. I did some testing with simple Excel where I put in one column time values. Regardless of Excel format (forced text format or time format) values shown in Power BI are like
10:00:00 tt
7:00:00 tt
they simply doesn't show the AM/PM as the suffix.
I've been informed by the Power BI Team that this shoul be fixed in the next update
Reproduced and confirmed in PBI Desktop. I sent a frown already; you should submit this as a bug as well.
