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. 

[Anonymous · Accepted solution]

Hi, @Ibrahim_shaik 

Based on your description, I have created DAX to achieve the effect you are looking for. Following picture shows the effect of the display.

DAX

HourColumn = FORMAT('Data'[Time], "HH:MM")

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Ibrahim_shaik]

Thank you for the response but this is not my requirement.

this is creates a Hour Column in this way

 I want the Every Hour timestamp like 01:00, 02:00, 03:00...... 23:00.

[ThxAlot]

Easy enough, add a calculated column of hour,