Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gandharv
Frequent Visitor

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

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_0-1710334894089.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vyifanwmsft_0-1710382574271.png


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

vyifanwmsft_1-1710382636634.png

vyifanwmsft_2-1710382682129.png

 

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

Final output in service:

vyifanwmsft_3-1710382745828.png

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.

View solution in original post

2 REPLIES 2
gandharv
Frequent Visitor

Thank you so much 🙂

Anonymous
Not applicable

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.

vyifanwmsft_0-1710382574271.png


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

vyifanwmsft_1-1710382636634.png

vyifanwmsft_2-1710382682129.png

 

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

Final output in service:

vyifanwmsft_3-1710382745828.png

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!