Time field does not display the record count on hourly basis

[vishnuragas]

I would want to display the number of tweets for each hour and below is the table. Below is the structure of the table. 

Below is how the graph should look.

But in Power BI, the number of records (S.No gets automatically aggregated as SUM of RECORDS). I split the date time field into a date, hour fields. But I don't get tweets by an hour but an aggregate of hours. Below is how the plot looks in POWER BI.

The fields in the pane are:

 

[v-cherch-msft]

Hi @vishnuragas

It seems you may check the aggregation of RECORDS as below. If it is not your case, please share your data sample or more details for us to check. You can upload it to OneDrive or Dropbox and post the link here or send me via private message.

Regards,

Cherie