11-08-2018 07:12 PM - edited 11-08-2018 07:21 PM
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:
11-11-2018 07:01 PM
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.