Forum Discussion
jmsousatavares
4 years agoRegular Visitor
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...
- 4 years ago
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
V-lianl-msft
Community Support
4 years agoBar 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