Vizualizing it might be a little tricky, but I figure I'll at least get you started.
first you'll need some kind of date table, if you don't have one you can create a new table with a measure like this:
Date =
CALENDAR (DATE(2020,1,1), DATE(2025,12,31))you'll likely want to make sure its a date as opposed to datetime
your active tasks measure will then be:
Active Tasks =
CALCULATE(
COUNTROWS('Tasks'),
FILTER(
'Tasks',
'Tasks'[Start Date] <= MAX('Date'[Date]) &&
'Tasks'[Complete Date] >= MIN('Date'[Date])
)
)Plugging that into a matrix does show that it works, but of course is not a good visualization of the data
As far as visualization goes it kind of depends on what you are wanting to see.
if you want to see multiple users simultaneously then you would probably ideally want to use a Gantt chart, but there isn't a default one, and I'm not aware of a free one on the store that would implement this without some kind of hacky solution.
another option would be to use a heatmap which is going to be likely much easier to implement, but may not be as visually clear or appealing.
if you want to look at only one or a few people at a time a calendar kind of format might work well
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
