Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Helper 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

Anonymous's avatar
Anonymous
Not applicable
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