Graph of average count represented on 24hr time line.

[Anonymous]

Hello all,

I have a table of tickets created in a helpdesk software for the last 5 years. I have a column of created date time and created time (in 24hr notation). I would like to present a graph that shows Hours on the x axis (0-24) and then the average count of tickets per hour. Any ideas would be lovely.

[amitchandak · Accepted solution]

@Anonymous , Create separate date and time columns and join them with date and time tables, have date and hour columns in respective tables

New column in your table

Date = datevalue([Created date])

Time = timevalue([Created date])

Create a measure like

sumx(values(Time[Hour]), calculate(sum(Table[Value])) )

Time Table
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-buckets

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.