Skip to main content

Power BI

Needs Votes

Display time in HH: mm: ss format in columns and bars charts

Vote (243) Share
Evandro's profile image

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)
Evandro's profile image Profile Picture

Phillip Putzback on 12 Apr 2023 12:35:01

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.

Evandro's profile image Profile Picture

Phil Pearson on 10 Sep 2021 13:23:35

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!

Evandro's profile image Profile Picture

Pragati Raj on 29 Jun 2021 06:36:44

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

Evandro's profile image Profile Picture

Santhosh Shasthri on 16 Aug 2020 04:17:20

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.

Evandro's profile image Profile Picture

soumya s on 16 Aug 2020 04:17:19

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.

Evandro's profile image Profile Picture

Colton Thompson on 16 Aug 2020 04:17:18

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.

Evandro's profile image Profile Picture

Conrad Roots on 16 Aug 2020 04:16:38

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.

Evandro's profile image Profile Picture

Power BI User on 16 Aug 2020 04:16:36

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.

Evandro's profile image Profile Picture

Raymond Boone on 16 Aug 2020 04:16:32

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...

Evandro's profile image Profile Picture

Gerhard from Vienna on 16 Aug 2020 04:16:07

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 !!! :-)