Forum Discussion

sfn's avatar
sfn
Frequent Visitor
9 years ago

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 63 h29.08.2016 22:0001.09.2016 13:00
Activity 2 3,5 h01.09.2016 13:0001.09.2016 16:30
Activity 3 8,5 h01.09.2016 16:3002.09.2016 01:00
Activity 5 2 h02.09.2016 01:0002.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