Power Bi Dashboard column, shows 12 hour date time format, when I would like to see 24 hour format.

[steggsy]

Hi all, happy friday.

So I am wondering whether you can help with my query. As you can see from my screen shot, when changing the format to what I require in the final visual to a new column, this seems to represent 3:23am instead of the 15:23 in the original custom column.

Any ideas, would be much appreciated how I could get this working? thank you

[danextian · Accepted solution]

Hi @steggsy ,

Please refer to the screenshot below:

Also, please remember that this will return a text string.

[samratpbi]

Hi, Instead of chaging the format in Power Query, you may apply the required format in Power BI itself. Once you are done with necessary transformation, simply select the column and in Format option of the date column, select the designed format to show in Date/time format