Power BI

Needs Votes

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

Vote (243)

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)

Comments (21)

Kendal Richardson on 16 Aug 2020 04:15:40

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

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.

Sarah on 16 Aug 2020 04:15:39

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

This would be very helpful to our end users.

Ahmad Mansoor on 16 Aug 2020 04:15:38

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

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.

Power BI User on 16 Aug 2020 04:14:24

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

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

Power BI User on 16 Aug 2020 04:13:59