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 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. 

Need Help
Show and Tell
Tips and Tricks

3 Replies

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

  • 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