Forum Discussion
Solved
line graph with hh:mm:ss variable in the value
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 t...
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
AlexisOlson
Super User
Super UserIf you click the dropdown on the Values field, does it give you other summarization options?
no, only count or count distinct