cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vishnuragas
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.

 

axis.PNG

 

 

 

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:

 

fields.PNG 

1 REPLY 1
Microsoft
Microsoft

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.

1.png

Regards,

Cherie

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

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors