Display time in HH: mm: ss format in columns and bars charts
We need to display time fields in the format (HH: mm: ss), in the stacked column chart / stacked bar chart.
We now convert the time to decimal to generate the graph.
01:30:00 (hh: mm: ss) = 1.5 (decimal)
In bar charts, the value property (FIELDS - VALUE option) will be 1.5
By activating the display data property (FORMAT - DATA-LABELS), the displayed value is 1.5.
Instead we need to display the data 01:30:00 (hh: mm: ss) DATA-LABELS.
Possibility to indicate which field to display in DATA-LABELS.
Hour_decimal (VALUE) = Hour (HH: mm: ss) display this field
Please, please make this happen. It's impossible to create meaningful visualisations for a contact centre without a simple plottable hh:mm:ss metric.
I create call center dashboards with PBI Report Server and this would be really helpful.
Raymond Boone commented
Another comment from someone dealing in response time tracking for a Fire Department. This would be very helpful. I can't imagine Fire Departments being the only ones who'd find this useful...
Gerhard from Vienna commented
I was trying out a lot and spent maybe 2 hours looking for a solution in DAX and even attempring some workarounds.
Only to find out that you'd finally need a native conversion function, like Evendro above described it:
integer --> time format (default notation hh:mm:ss)
Given you have an integer number of 2456 representing seconds and you would like to display it in time format and the name of the new function is TIMECONVERT
It should work out like that:
Default result: 00:40:56 meaning 40 minutes and 56 seconds.
As with any time format you should be able to format to display any other notation like just mm:ss or dd:hh:mm:ss
As with any native format in PBI we should then also be able to have an y-axis in a diagram displaying values formatted this way and you should also be able to calculate with values in this format.
Example: 00:40:56 - 00:21:01 = 00:19:55 etc.
As, like the many votes you can see here, this is an IMPORTANT and success-critical features, still missing, I'd kindly ask the PBI development team to have a look into it and surprise us with maybe the December 2019 release, already coming with this feature !!! :-)
This would be very helpful to our end users.
Using time metrics is a major function of the reporting department in Fire. More than one user has asked for TIME data labels rather than the number of seconds. We really need this functionality.
Ahmad Mansoor commented
I have a column of duration values and need to report on total duration for some rows. Right now my values are being converted into floats, so this is really necessary.
For time performance reporting this is an essential element. Without it we have to present our charts in tableau and excel. This will be a game changer if you can get it into Report server. Until that point Excel ODBC linked and Tableau win hands down
Desperate for this really basic formatting of the axis
I work with some detailed call center metrics and this feature would be incredibly helpful
Rafael Schweder commented
This would be very helpful
I need this
This would be extremely helpful
Simon Wilcox commented
This would be very useful for us. Our time recording system stores in seconds, a friendly hh::mm:ss display would help comprehension of the data
Ken Loewen commented
We need this for scatter and line charts, as well as column and bar charts