24 hours changing to 12 hours after publishing to the report server

[Tlotly]

Good day

Please assist.

I have a time visual which shows 24 hours on the x axis. It works fine on desktop as well as when publishing to the report server. But after a scheduled refresh, it shows 12 hours instead of 24 hours.

Desktop

After server refresh

Dax used to create the hour column:

Hours1 = FORMAT([TimeStart - hours - Copy.2],"HH AM/PM")

I formatted the date used to create the hour column to datetimezone.

Date column:

I also checked the format on my machine as well as on the server, it's using the timezone below:

How do I fix this?

Thank you in advance

[Tlotly]

Hi @v-yiruan-msft 

Thank you for the response. I managed to get sorted this morning. 

Firstly, I changed the format of my date column ( [TimeStart]) on Power Query to datetime. I then created a custom column using my date column i.e. DateTime.ToText([TimeStart],"dd-MM-yyyy HH:mm:ss"). Lastly, I used the custom column to create the Hours column, and it works perfectly.

This is how it's showing now after scheduled refresh on Report Server:

But back to your questions:

1. I've attached the correct second screenshot on the original post.

2. I used Hours for the x axis. Dax used to create it: Hours1 = FORMAT([TimeStart - hours - Copy.2],"HH AM/PM")

3. And yes the data type is Time

Thank you

[v-yiruan-msft]

Hi @Tlotly ,

As checked the screenshots which you shared(the first and second one), it seems that they are same. Could you please confirm that? Which field be applied on X axis of column chart? What's the data type of that field? Is it Time type?

Best Regards