line graph with hh:mm:ss variable in the value

[jmsousatavares]

Hello,

how can I create a line graph with this variable?

when I push the variable TMP to the value of the line graph, a count occurs and only show an integer and not the average or the absolute value of the variable (in hh:mm:ss format)

[V-lianl-msft · Accepted solution]

Bar charts and line charts do not support fields in time format as values.

You need to convert time into seconds or minutes. You can refer to the these:

DAX:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92 

Power Query:

https://community.powerbi.com/t5/Desktop/Convert-HH-MM-SS-to-seconds/td-p/1185671 

[VijayP]

@jmsousatavares 

Please check the Data type of that columns, looks like that column got converted to Text hence it is just showing Count, Change the data type as desired

[jmsousatavares]

Hello,

the type is "time"

[VijayP]

@jmsousatavares 

Then convert that into text and add that field and see whether you get the work around

[jmsousatavares]

@VijayP  it didn't work. 

[AlexisOlson]

If you click the dropdown on the Values field, does it give you other summarization options?

[jmsousatavares]

no, only count or count distinct