Forum Discussion

terpsbmore's avatar
terpsbmore
Icon for Helper I rankHelper I
8 years ago

Displaying time as a number

Hello All,   I have been using Power Bi Service to connect to PowerPivot. I have formatted all of my columns correctly (number, decimal, time, etc..) however I am not able to get my time data to di...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi terpsbmore,

 

Did you attempt to display time field formatted like hh:mm:ss as values in a clustered chart? The Y-axis of a chart visual only supports numeric values, and fields added to it will be aggregated by default. If you add date or time or text field into Y-axis, it will be counted.

 

So, in your scenario, you have to convert the time field to numeric values. For example, convert 06:06:06 to 21966 seconds (or 0.27 days).

 

Best regards,
Yuliana Gu

terpsbmore's avatar
terpsbmore
Icon for Helper I rankHelper I
8 years ago

Thanks for the reply v-yulgu-msft,

 

I have tried what you mentioned and formatted the time as a number and it sorts like it should. However, the issue I am having is the end user (consumer) of the chart will want to know the length of time at a glance and not have to figure out the conversion of the numerical value. I might decide to display in a table format. I appreciate the help!