How to Aggregate Data Hourly and Display in a Line Chart

Ibrahim_shaik — Fri, 08 Mar 2024 12:34:04 GMT

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.

Re: How to Aggregate Data Hourly and Display in a Line Chart

lbendlin — Fri, 08 Mar 2024 22:48:16 GMT

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.