Skip to main content

Power BI

Needs Votes

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

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

ed0ec146 85f7-41df-9a48-d620993dc5a1 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

Evandro's profile image Profile Picture

ed0ec146 85f7-41df-9a48-d620993dc5a1 on 16 Aug 2020 04:13:59

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

Desperate for this really basic formatting of the axis

Evandro's profile image Profile Picture

b5f70140 322f-4e14-901c-ae7b216c8cc1 on 16 Aug 2020 04:12:32

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

I work with some detailed call center metrics and this feature would be incredibly helpful

Evandro's profile image Profile Picture

16eb7321 28db-4445-a691-bd1fa93a4669 on 16 Aug 2020 04:11:44

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

This would be very helpful

Evandro's profile image Profile Picture

3a05a2ff 2fc5-4155-bed8-03563ce381af on 16 Aug 2020 04:10:59

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

I need this

Evandro's profile image Profile Picture

8d3f9b9b 5afb-4eff-ac63-26302acb76d2 on 16 Aug 2020 04:10:48

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

This would be extremely helpful

Evandro's profile image Profile Picture

96475027 5c7a-4952-bb82-cde7590411fb on 16 Aug 2020 04:10:23

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

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

Evandro's profile image Profile Picture

5fc6d462 b75c-e911-a95f-000d3a4f3883 on 16 Aug 2020 04:08:13

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

We need this for scatter and line charts, as well as column and bar charts