Forum Discussion
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 around? I need it to show the actual times in the first table
Actual times
Changed times when published
Please help!!!
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!
2 Replies
You need to manually format your values as durations. Power BI doesn't have that data type. (Only Power Query has it)
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!
