Evandro on 13 Mar 2018 23:55:56
We need to display time fields in the format (HH: mm: ss), in the stacked column chart / stacked bar chart.
Explanation:
We now convert the time to decimal to generate the graph.
Example:
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.
Suggestion:
Possibility to indicate which field to display in DATA-LABELS.
Hour_decimal (VALUE) = Hour (HH: mm: ss) display this field
- Comments (21)
RE: Display time in HH: mm: ss format in columns and bars charts
Why is this taking so long to implement. Internally, isn't time a number? When setting the format, why isn't that metadata kept separate of the actual value, so the calcs can use the value and the displayed value can use the metadata.
RE: Display time in HH: mm: ss format in columns and bars charts
That workaround Pragati Raj is great, Will save me loads of time!
RE: Display time in HH: mm: ss format in columns and bars charts
Hello Team,
I don't know if this works for you or not but actually I found same issue
so I workaround and found a solution .....
create a measure in sec and put format 00:00:00 for hh:mm:ss and 00:00 for mm:ss
thanks
Pragati Raj
RE: Display time in HH: mm: ss format in columns and bars charts
Even me to waiting for this. Also duration datatype will not work in direct mode. It would be great if duration datatype is made available even in direct mode.
RE: Display time in HH: mm: ss format in columns and bars charts
I am also waiting for this requirement it is quite important to have this feature in Power BI to showcase the data in HH:MM:SS format.
RE: Display time in HH: mm: ss format in columns and bars charts
This sounds like a great idea. I can't get time to show up on these graphs in the quick service restaurant industry tracking time is one of our key metrics.
RE: Display time in HH: mm: ss format in columns and bars charts
Please, please make this happen. It's impossible to create meaningful visualisations for a contact centre without a simple plottable hh:mm:ss metric.
RE: Display time in HH: mm: ss format in columns and bars charts
I create call center dashboards with PBI Report Server and this would be really helpful.
RE: Display time in HH: mm: ss format in columns and bars charts
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...
RE: Display time in HH: mm: ss format in columns and bars charts
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)
Example/Requirement:
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:
TIMECONVERT (2456)
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 !!! :-)