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
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
Hello,
the type is "time"
Then convert that into text and add that field and see whether you get the work around