How can we improve Power BI?

field of "duration" type

is it possible to add support for "duration" data type in the report view as in Power Query?

737 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Daniel wu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

117 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    this is probably the most important addition that we have been waiting for for AGES.....

  • Simon commented  ·   ·  Flag as inappropriate

    All I want is to format seconds as hh:mm:ss, e.g. 25:59:59. Is this too much to ask?

  • Chris99 commented  ·   ·  Flag as inappropriate

    Unbelievable omission. Would anyone like to guess what an average elapsed time of 1443279 seconds is? Of course not, it's nonsense.

    What is even more bizarre is that when you Edit Query there is a type of Duration.

    Is there any comments from MS employees on progress of this feature, as without it Power BI is unsellable to our customers.

  • Charles commented  ·   ·  Flag as inappropriate

    Lack of Power BI's understanding of hh:mm:ss is killing me. I have to convert time duration to measures but measures DO NOT work in tool tips. So in my table I'm showing 61 secs as 00:01:01. In the tooltip the measures shows a 0? Argghhh!!!!

  • Anonymous commented  ·   ·  Flag as inappropriate

    ...quick add for others who see this thread. You can use the software to plot the same trends using a time to decimal conversion. Convert the time to Military format then divide it up by 60 depending on hours or minutes and you can do a halfway decent KPI plot on the Y axis using the time in decimal format. For example 8:45 PM would be 20:45 military time and 20.75 in decimal. .75= 3/4 hour if I have the right conversion formula based on posts out there

  • Anonymous commented  ·   ·  Flag as inappropriate

    yes yes YES. Several local companies in the billons of dollars range would like to see KPI visuals that plot time quicker and easier. There is a tremendous of historical and trend tracking done by corporate America.

    Microsoft please tag this one a must have at some point.

  • Rob Sims commented  ·   ·  Flag as inappropriate

    I'm producing production planning outputs, got to have a duration based Y axis, especially as there is an easy way to convert data to duration!!

  • Anonymous commented  ·   ·  Flag as inappropriate

    need visualization of sales as they relate to the duration of marketing campaign(s)

  • Muki commented  ·   ·  Flag as inappropriate

    what's the status here? is there a workaround for this pls? I have duration in d.hh:mm:ss in my query editor but can't use this data in my reports? have to make a sum of this data in my reports...

  • James commented  ·   ·  Flag as inappropriate

    This type of field is really necessary for cases such as Call Center and Help Desks and Service Desks to deal with duration of calls and attentions, many times it is necessary to work with average and more calculations, for which you have to extend fields and use a lot of extra for this.

    And even if you set the field as duration in the Query Editor window, it is useless when you try to use it in the Reports Window

  • Anonymous commented  ·   ·  Flag as inappropriate

    Power Bi team, this kind of data type is a must have for telehealth call centres... my bosses would like to have an average of this in 00:00:00 format. And in addition to this, they would like to have conditional formatting as well to spot call handling time that is above the threshold. it would be really useful having this as a data type and can be conditonally formatted with colors.

  • Sunil commented  ·   ·  Flag as inappropriate

    Hello PerBI Team, amazing job what you've done so far. Can we please have "time duration" on X axis ..so that I can show Sales by every hour in a given day, for example. Thank you.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.