Forum Discussion
Vishnu_Kas
3 years agoNew Member
Power BI Stacked chart - Time vs Category visual
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 |
I really appreciate the help! Looking forward to the tips/solution.
Regards
Vishnu
No RepliesBe the first to reply