Time cannot be set to 24 hour format in Continuous X Axis

[GlobalFever]

Hi,

I've got a column which is in "Time" data type.

It is used as X-axis in an Area Chart, continous.

What I've found is that in Desktop it is showing as 24 hour format whereas it will be showing AM/PM no matter how I configure the format in column tool. 

Actually the format function only works when I set this axis as categorical.

Could you please help me out? 

Screenshots in desktop:

The "Hour" column is set as h:nn in desktop:

Still showing AM/PM in the portal:

[v-stephen-msft · Accepted solution]

Hi @GlobalFever ,

If it is not a table visual, it will indeed automatically become the twelve hour format.

Here's the workaround, you can turn the time field to text.

24hr = FORMAT([Time],"HH:mm:ss")

Then you need to sort the 24hr column by the time column.

Now you can get the time in 24-hour format.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GlobalFever]

Hi Stephen,

Thanks for replying.

Yes by using text format time value, we can show them in 12h or 24h as we want.

But in this case the time value will be categorically,

which means the X axis must be showing every hour point, and the X axis gridlines will be lost.

[lbendlin]

Is the locale of your browser set to en-us?