Forum Discussion
Advocate IITime cannot be set to 24 hour format in Continuous X Axis
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.
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.
Advocate IIHi 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.
Have you figured out this problem? I have been having the same issue plague me for a couple years now.
