Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
2 years ago

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.