Forum Discussion
Adham
Helper III
Helper IIIPlotting Duration as continuous line graph
Hello All, I am have been stuck on this for a while and i would really appreciate help on this. I have got experimental data where i have got several readings for each experiment and the duration...
AllisonKennedy
Community Champion
Community ChampionDuration data type is only supported in Power Query Editor, not in Power BI report, so you should try making it decimal number to achieve the continuous result you're looking for.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#:~:text=Power%20BI%20Desktop%20supports%20three,it%20also%20handles%20whole%20numbers.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#:~:text=Power%20BI%20Desktop%20supports%20three,it%20also%20handles%20whole%20numbers.
AdhamHelper III
Helper IIIHow can i convert hh:mm:ss into decimal? I think it would work if it was in hh:mm or mm:ss but in my case it is slightly different
- AllisonKennedyI think Power BI handles this in a similar way to Excel - assuming that 1=1day=24hours=1440minutes = 86400seconds
So for converting hh:mm:ss into decimal you would basically take
(24/hh)+(1440/mm)+(86400/ss)
If you wanted to you could customize this and set 1 hour = 1 and update the above formula, depending on what units you want on your axis.