Time duration couldn't show the correct format on dashboard

[Clarafang]

Hi guys,

I am a green-hand to use power BI, and I get a issue when I make the dashboard. I have no idea why the duration shows totally wrong on dashboard , can anyone help me find out what is the problem? thanks!

on the date view

on the report view

[v-yalanwu-msft]

Hi, @Clarafang ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi., @Clarafang ;

My understanding is that the data storage type and the data visualization type cannot be completely consistent.

For example, in power query there are duration, date/time/time zone, percentage type, which is not in power bi, but power bi can format the data as the above type.

If you do not format the data, power bi needs to select a data type for the data first, with percentage as decimal, date /time/time zone as date, duration as decimal, etc.
When you convert the data to percentage type in power query, but power bi can only treat it as a decimal, then you can format the data as a percentage to display the data.

You can vote on the idea so that developers can implement it faster.

https://ideas.powerbi.com/ideas/idea/?ideaid=8b5c6118-6b4f-458b-a715-80de0ee1ba9e

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Please see this article. You are better off changing the type of your data to decimal and formatting it to the desired format in your measure.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[tackytechtom]

Hi @Clarafang ,

You might wanna try changing the format:

Does this help? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[serpiva64]

Hi,

you have to try to choose this format

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !