Skip to main content

Power BI

Needs Votes

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

Vote (244) 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

Ken Loewen 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