Which visual is best- graphing times of day over time for trends>daily,weekly,monthly,yearly?

[PbiConsult1]

Anyone done this and have a preferred way or visual?

We need to plot a time of day for several variables each day over time, by day, week, month, year

Data looks like this

Variable 1                         Variable 2                               Variable 3

02/15/2018   3:05 PM      02/15/2018   4:09 PM            etc.

02/16/2018   6:24 PM      02/6/2018     9:43 AM

[v-shex-msft · Accepted solution]

HI @PbiConsult1,

I'd like to suggest you enter to query editor and use unpivot column feature to format your records.

Reference:

Pivot and Unpivot with Power BI

>>We need to plot a time of day for several variables each day over time, by day, week, month, year

I think matrix visual will be suitable, if you drag date column to row field, it will auto summary with each data hierarchy level.

Sample:

Week = WEEKNUM([Date],1) 

Regards,

Xiaoxin Sheng

[PbiConsult1]

We need to do a graph with an X and Y access or something very similar.

Appreciate you taking the time to post to help!