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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

For the life of me, I cannot recreate this. Are you on the January update and are there any regional language settings involved?

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

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Reproduced and confirmed in PBI Desktop. I sent a frown already; you should submit this as a bug as well.