PowerBI adding AM and PM to the the time

[Anonymous]

Hi, 

Please can I get advise on how to remove PowerBI adding AM and PM to the time tables on the server?

It only updates on the workspace itself not the desktop. 

Thank you

[Anonymous]

Thank you! 

[collinq · Accepted solution]

Hi @Anonymous ,

The way that the Date data is displayed is based on the data you bring in, the  Data Type in the query and the choice you made in the visual/table view for the format.  If the Data Type is Date/Time, has the AM?PM and/or has 24 hour time in it, and you have the format set to show the AM/PM then it is going to display.

If you want to remove that, change the Format to the desired output.  Just select the field and the Format option.