Forum Discussion
Responsive ResidentStacked Bar Chart with Start Time, Duration and Multiple Activities on One Row
Hi, ConnieMaldonado
Based on your description, I creatad data to reproduce your scenario.
Table:
Duration is a calculated column as below.
Duration = DATEDIFF('Table'[Start time],'Table'[End Time],MINUTE)You may use Gantt 2.2.3 from marketplace, go to 'Visualization' ribbon, click 'Formatting'=>'General', set 'Duration unit' as 'Seconds' and 'Duration min' as 0, click 'Date type', set 'Type' as 'Hour'.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ConnieMaldonado BA_Pete kewaynes v-alq-msft ,
I have a quick query in regard to how to use a stacked bar chart in Power BI which would show the category vs. Time.
I was able to create one in Excel using time series But trying to figure out the same in Power BI Visual.
It would be really helpful if someone could share their thoughts on the same. Please feel free to reach out to me on any additional information.
Excel Graph:
I colored the cells of Layover to White (So it shows as a gap), Blue highlighted are all Travel times.
Raw data Sample:
| ID Number | Start Time | Travel | Layover | Travel | Layover | Travel | Layover | Travel | Layover | Travel | Layover | Travel |
| 3 | 05:25:00 | 00:23:00 | 00:07:00 | 00:31:00 | 00:14:00 | 00:30:00 | 00:15:00 | 00:42:00 | 00:18:00 | 00:40:00 | 00:20:00 | 00:36:00 |
| 4 | 05:25:00 | 00:23:00 | 00:07:00 | 00:25:00 | 00:05:00 | 00:32:00 | 00:13:00 | 00:40:00 | 00:20:00 | 00:45:00 | 00:15:00 | 00:37:00 |
Regards
Vishnu
- BA_Pete
Super User
Hi Vishnu_Kas ,
I suggest that you open a new post in the Desktop forum for this: Desktop forum
You'll have a far higher chance of getting a quick resolution there.
Pete
