Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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

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
Status: Needs Votes
Comments
fbcideas_migusr
New Member

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.

fbcideas_migusr
New Member
Status changed to: Needs Votes