topic Re: need help with plotting frequency of an events occurring during a day in DAX Commands and Tips

need help with plotting frequency of an events occurring during a day

Anonymous — Wed, 17 Jun 2020 13:49:13 GMT

I need help plotting timestamped data of events. The data looks like below table . I am hoping to plot on x axis - times of the day like 8:00 AM, 8:30 AM ,9:00 AM -- so on.. and on y axis i want to show count of events occuiring during that time.

This data is contineous ie hunderds of events happen any given day.

Any help would be highly appreciated,

Thanks in advance.

Column A (date when event occurs)	Column B ( time when event occurs)	Column C ( event, can repeat multiple times a day )
11-June-2020	11:34:04 AM	event A
11-June -2020	1:23:45 PM	event B
12-June-2020	8:00:01 AM	event A
12-June-2020	9:00:10 AM	event B
13-June -2020	02:06:34 PM	event C

Re: need help with plotting frequency of an events occurring during a day

lbendlin — Thu, 18 Jun 2020 00:16:42 GMT

when you say "plot" what do you mean? Line chart, scatter plot, or something else?

For a scatter plot you need to convert your column C into a numerical value before putting it on the Y axis.

Combine columns A and B into a datetime value and put it on the X axis . Note that Scatter plots cannot display a lot of data, very quickly you will see a warning that grouping is happening.

Re: need help with plotting frequency of an events occurring during a day

Anonymous — Thu, 18 Jun 2020 04:13:13 GMT

Hi Anonymous ,

Have a look at this video.

https://www.youtube.com/watch?v=D-Z1k5o0upo&feature=youtu.be

Combine the Date and Time Column in Power Query.

Post that you can just drag the new created Column and Events Column on a bar, line chart. You can apply Count in the Events Column.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)