Stacked Bar Chart with Multiple Activities on One Row

[ConnieMaldonado]

I need to create a bar chart that shows time intervals for activities on a bar chart.  I tried a couple of Gantt chart visuals, but I can't get an hourly timescale, and the visual sums the duration by category rather than showing the each activity.  I created the images below in Excel.  I tried a few things using a stacked bar chart in Power BI but couldn't get it to work.  Any ideas would be appreciated!  Thanks

[Anonymous]

There are several other ways to combine the clustered and stacked column charts together (such as adding the legend entries, arranging the target range with blank rows and others).

[ConnieMaldonado]

Ok - that sounds good.  In terms of adding the legend entries, how do I get the start times to appear on the x-axis.  If there's a video or something I can watch, let me know!  Once I'm on the right path, I'm pretty good at figuring it out.  I can also manipulate the data however needed.  Thank you.

[v-frfei-msft]

Hi @ConnieMaldonado ,

There is no Hour type for current version of Gantt visual. Please vote this idea here to make it possible in future version.

[ConnieMaldonado]

Yep, thanks.  Gantt charts are out, as none of them have an hourly time scale.  Also, none allow you to show multiple activities on one row - all the activities are shown separately.  In Excel, I had to use a stacked bar chart with 3 series - series 1: start time (with no fill so it wouldn't show), series 2: duration, series 3: 3 points representing the categories on the secondary axis (this allowed the categories to display on vertical axis).    You're basically adding both series (one that shows the entire line with no fill) and then overlaying the duration for the activity (with a color).  See image (which is from Excel).  It helps me to figure out how to get the chart to work in Excel first.  🙂  I believe I need to look for an enhanced bar chart visual. 

From Excel: