How to Aggregate Data Hourly and Display in a Line Chart

[Ibrahim_shaik]

Hi Power BI Community,

I have a "time" column with 5 minute interval timestamps like 00:01:01, 00:05:01 and a number column which has decimal values.

How to aggregate values by hour and display the data Hourly on the Line Chart in Power BI.

I Used drill up it shows only daily data but not Every hour in a day.

Please give a solution.

Thanks&Regards,

Ibrahim. 

[lbendlin · Accepted solution]

You have fallen victim of the blue "i" - forced sampling because you have too many data points.

You need to pre-aggregate your data before you can render it in the visual. add  a HOUR() column to your fact table and use that.