Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi All,
I am trying to calculate the count of buses between the start and end time.
The table consist of 3 columns: Start time(hrs),End time(hrs) and Bus Number. I have also created a series table which has list of all the timings between start and end time. A graph should be generated with series time in the axis and count of bus in the value.
above is the sample from excel.
I have attached the pbix file for reference.
Here are some options for visualizing the count of buses with start and end times. I have updated the pbix and re-attached.
Page: Sample 1
Page: Sample 2
https://1drv.ms/u/s!AkCe6_YwGEfWg7QFSQQGG7zRc6owXw?e=09AcY7
Thank you.
This is helpful, however is there any chance to make this work using generating a series of time and establishing the relationship between them. I was trying to understand why the pbix file which I attached is not working.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.