topic Re: line graph with hh:mm:ss variable in the value in Developer

line graph with hh:mm:ss variable in the value

jmsousatavares — Mon, 08 Nov 2021 21:18:23 GMT

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)

Re: line graph with hh:mm:ss variable in the value

AlexisOlson — Mon, 08 Nov 2021 21:33:52 GMT

If you click the dropdown on the Values field, does it give you other summarization options?

Re: line graph with hh:mm:ss variable in the value

jmsousatavares — Mon, 08 Nov 2021 22:31:06 GMT

no, only count or count distinct

Re: line graph with hh:mm:ss variable in the value

VijayP — Tue, 09 Nov 2021 10:42:03 GMT

@jmsousatavares

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

Re: line graph with hh:mm:ss variable in the value

jmsousatavares — Tue, 09 Nov 2021 12:51:16 GMT

Hello,

the type is "time"

Re: line graph with hh:mm:ss variable in the value

VijayP — Tue, 09 Nov 2021 15:47:46 GMT

@jmsousatavares

Then convert that into text and add that field and see whether you get the work around

Re: line graph with hh:mm:ss variable in the value

jmsousatavares — Tue, 09 Nov 2021 16:50:24 GMT

@VijayP it didn't work.

Re: line graph with hh:mm:ss variable in the value

V-lianl-msft — Thu, 11 Nov 2021 06:21:18 GMT

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