Forum Discussion

Vishnu_Kas's avatar
Vishnu_Kas
New Member
3 years ago

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 NumberStart TimeTravelLayoverTravelLayoverTravelLayoverTravelLayoverTravelLayoverTravel
305:25:0000:23:0000:07:0000:31:0000:14:0000:30:0000:15:0000:42:0000:18:0000:40:0000:20:0000:36:00
405:25:0000:23:0000:07:0000:25:0000:05:0000:32:0000:13:0000:40:0000:20:0000:45:0000:15:0000:37:00

 

I really appreciate the help! Looking forward to the tips/solution.

 

Regards

Vishnu

No RepliesBe the first to reply