Forum Discussion
Helper VHow to Aggregate Data Hourly and Display in a Line Chart
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.
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.
1 Reply
- lbendlin
Super User
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.