Times Changing when published

[shabs66]

Hi,

I have created a table in my powerbi report showing average response times, when i publish to a sharepoint page it changes the times to actual times, screen shots below. Is there a work around? I need it to show the actual times in the first table

Actual times

Changed times when published

Please help!!!

[Anonymous · Accepted solution]

Hi @shabs66 

This is because the Duration data type is not supported in Report view. It only exists in Power Query Editor. One workaround is to change the time-format duration values to Text type. Then they can be displayed in Table visual. But this practice doesn't work if you want to display them in visuals which expects numeric values. 

Or you can try another workaround from Chelsie Eiden's Duration - Microsoft Fabric Community. It resolved the above concern. 

Hope this will be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

You need to manually format your values as durations.  Power BI doesn't have that data type. (Only Power Query has it)