Forum Discussion
Solved
Times Changing when published
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 aroun...
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!
You need to manually format your values as durations. Power BI doesn't have that data type. (Only Power Query has it)