Graphing the time email messages are sent

[Anonymous]

Hi,

I have setup an O365 mail account where we CC a single daily email message. I have conencted Power BI to the mailbox and am trying to create a simple line graph showing every day the time that the mail is sent.

After lots of searching I found that if I diplicate the date\time sent column and set one to type date and the other to type time, I can get seperate date and time values.

 I want to create a graph that shows the time the mail was ent for each date. What I can't seem to get rid of is the count of date. I have seen and tried all sorts of things.

Any ideas ??

Thanks, 

[v-lili6-msft]

hi, @Anonymous

After my research, I'm afraid it couldn't achieve in Power BI for now.

First, found that if I diplicate the date\time sent column and set one to type date and the other to type time, I can get seperate date and time values.

You just change the datetype of the two column, but the actual value doesn't change, the same time but different date is not equal although they are seen same in data view,

you could use these two formula to add two columns then change the data type of them.

date = DATE(YEAR('Table'[date sent]),MONTH('Table'[date sent]),DAY('Table'[date sent]))


time = TIME(HOUR('Table'[date sent]),MINUTE('Table'[date sent]),SECOND('Table'[date sent]))

Second, line chart and bar chart are all aggregation graphics. so values must be "count""sum", etc.

You may try to use a table visual for your requirement, like 

Best Regards,

Lin