Forum Discussion
Report sells date datetime format automatically changes from 24hr format to 12Hr format
Hi AmitTailor27 ,
Try to force the change of the date/time to a timezone:
The default ones used by Power BI usually revert to the ones on the service because you are not setting it has a fixed value.
Also try to for the format on the column in the desktop instead of using the default one that may match your computer but changing location also change that format:
Hi MFelix ,
I have tried Solution suggested by you .
on Transformation data I have fixed date format .
after that data looks fine on PowerBi desktop .
but after publishing it again changed to 12h format .
Please help !!
Hi AmitTailor27
You also need to force the format of the column, on the images below you can see two values one with the default value and the other (2) with the force date check the image on Desktop and on service:
You can see that on the service date 2 is having the correct value use the following code for the format:
dd/mm/yyyy hh:mm:ss