Forum Discussion

amilcrrr's avatar
amilcrrr
New Member
2 years ago

Power BI not taking time format settings from excel

Hi Team,  I've built a timeline with date and time hh:mm:ss in excel, but when visualizing the data in Power BI it's defaulting ALL the seconds back to zero.  Excel  Power BI  ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amilcrrr ,

 

I notice that the time in the desktop is missing the seconds part, have you converted it in PowerQuery? Please check that.

Then format the datetime column using code like this:

mmmm-dd hh:nn:ss

Output:

The test file is attached for reference. If this does not work, please feel free to contact us.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

amilcrrr's avatar
amilcrrr
New Member
2 years ago

There might something else going on. I've updated and change ALL the formats above but its doesn't inherit the second still 

 

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    amilcrrr 

     

    Please provide your source data and the file with the issue.  Much easier to check what's going on then.

     

    regards

     

    Phil