Time format issue on charts, discrepancy between Power BI Service and Power BI Desktop

[gandharv]

Hi All, 

I have published my Dashboard on Power BI Service and noticed a change in the time format of the charts. I tried changing the time format of the time column in my table from 00:00:00 (long time) to 00:00 (hh:nn), but it didn't work. Any suggestions:

[gandharv]

Thank you so much 🙂

[Anonymous · Accepted solution]

Hi @gandharv ,

Based on your description, it appears that you have tried to adjust the time formatting directly in the table, but it is not reflected in the Power BI service as expected.

The Power BI service may interpret date and time formats based on the regional settings of your Power BI account or the regional settings of your browser. Ensure that these settings are consistent with the expected format. Adjusting the regional settings in Power BI Desktop before publishing may help achieve consistency.

If the above does not solve your problem, you can follow these steps:
1. Add a new column in Power Query to display the time in the correct format.

= Table.AddColumn(#"Changed Type", "Time_", each Text.From(Time.Hour([Time]))&":"&Text.PadStart(Text.From(Time.Minute([Time])),2,"0"))

2. Add an index column.

3. Place the new column in the bar chart and place the index column in tooltip ascending order.

Re-upload the report to Power Bi Service and it will display correctly.

Final output in service:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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