Forum Discussion

emteka's avatar
emteka
Icon for Advocate I rankAdvocate I
10 years ago

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:...
Need Help
emteka's avatar
emteka
Icon for Advocate I rankAdvocate I
10 years ago

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.

 

 

 

 

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago

I've been informed by the Power BI Team that this shoul be fixed in the next update