Forum Discussion
Stacked bar chart with concurrent events between datetimes
Thanks for reply, but I need both timeline and duration to be displayed on the x-axis because the Y-axis is needed to be available for "number of concurrent sessions". I think the answer is that power BI (without R) can't manage the concept of time duration as part of a timeline on the x-axis. Something similar is the Gantt chart in the custom visuals section, but not usable in this case.
Hi AGo
Could you post some simplified data and expected output like this post?It seems you may create a second column with DATEDIFF Function.
Regards,
Cherie
Sure, here's the dataset.
Dataset
I calculated also a "Session End DateTime" based on the duration field.
The concept is that every record represent a session which value is equal to one when active from start to end.
The graph should display the time line on the X-axis an the number of concurrent active sessions on the Y-axis, having the working session technician names when consulting would be welcome. So a stacked bar chart with legenda or a line chart with command description should work. The problem with the bar chart is that you can't script how wide the bar should be (eg. from 01/01/01 20pm to 01/01/01 22pm) but its representation is based on a punctual datetime. Someone has a smart way to solve this way of represent duration/interval data?
Thanks for reply, but I need both timeline and duration to be displayed on the x-axis because the Y-axis is needed to be available for "number of concurrent sessions". I think the answer is that power BI (without R) can't manage the concept of time duration as part of a timeline on the x-axis. Something similar is the Gantt chart in the custom visuals section, but not usable in this case.