Forum Discussion

Ibrahim_shaik's avatar
2 years ago
Solved

How 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...
  • lbendlin's avatar
    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.