Forum Discussion
Post PatronStacked 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.
Post PatronSure, 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?
Microsoft Employee- AGo
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.