Showing results for 
Search instead for 
Did you mean: 
vishnuragas Frequent Visitor
Frequent Visitor

Time field does not display the record count on hourly basis


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



tweet_power bi.PNG






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.






twee by time.PNG



The fields in the pane are:



v-cherch-msft Super Contributor
Super Contributor

Re: Time field does not display the record count on hourly basis

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.




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

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 345 members 3,294 guests
Please welcome our newest community members: