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
djnww's avatar
djnww
Icon for Impactful Individual rankImpactful Individual
10 years ago

I believe he is saying that when you load a Date/Time into Power BI Desktop and select a date/time format with 'TT', it doesn't return AM/PM.

 

It just returns 'tt' instead of AM/PM.

 

I have recreated the problem by importing an Excel spreadsheet with a number of date/times into Power BI Desktop. I haven't figured out how to fix it as yet.

  • 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