Forum Discussion
Group datetime data by date and hour for comparison line graph
Hi All, Appreciate if you can help me with this report. I have a raw data as below table. Attached in excel. I would like to create a table and a line graph to show the comparison of differen...
amitchandak
Super User
Super UserAnonymous . Not very clear.
Separate the time and then Two option I can think of
Time = [Update Datetime].time
1. Use the time on-axis and slicer
2. Create a time table and have an hour there. and use that for analysis :https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
Hi amitchandak,
Thank you for your reply. Im sorry if Im not being clear.
I have created a new column by date & hours from the initial update_time column as below:
Do you know how to group by Production line, hourly with the max(actual_val) - min(actual_val) new actual column ?
Please advise. Thank you.
Regards.
Jenas