Forum Discussion
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 the absolute value of the variable (in hh:mm:ss format)
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
7 Replies
If you click the dropdown on the Values field, does it give you other summarization options?
no, only count or count distinct
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
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
