Forum Discussion
Ibrahim_shaik
Helper V
2 years agoHow 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 displ...
- 2 years ago
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.
lbendlin
Super User
2 years agoYou 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.