Reply
Frequent Visitor
Posts: 10
Registered: ‎01-10-2018
Accepted Solution

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

[ Edited ]

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

 

 


Accepted Solutions
Community Support Team
Posts: 7,711
Registered: ‎08-14-2016

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

[ Edited ]

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) 

10.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post


All Replies
Community Support Team
Posts: 7,711
Registered: ‎08-14-2016

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

[ Edited ]

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) 

10.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Frequent Visitor
Posts: 10
Registered: ‎01-10-2018

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

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!