Forum Discussion
sfn
9 years agoFrequent Visitor
Visualising activity duration/day in a bar chart
Hi!
First of all I would like to commend this community for being an excellent resource - I've just recently discovered the greatness of PowerBI and I'm now looking for some guidance on how to climb this wall I've met.
The goal is to visualise a plan of activities, with start and end timestamps, onto a bar chart, where each bar resemble 24 hours of a day.
The data of the activity is as follows;
| Name of activity | start date and time | end date and time |
Example:
| Activity 1 | 29.08.2016 22:00 | 01.09.2016 13:00 | ||
| Activity 2 | 01.09.2016 13:00 | 01.09.2016 16:30 | ||
| Activity 3 | 01.09.2016 16:30 | 02.09.2016 01:00 | ||
| Activity 5 | 02.09.2016 01:00 | 02.09.2016 03:00 |
And output should be something similar to below example:
Appreciate any input/ideas on how I can achieve this.
Best regards,
Stian
No RepliesBe the first to reply