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
VijayP
Community Champion
Community ChampionThen convert that into text and add that field and see whether you get the work around
