Matrix as Gantt Chart for Room Utilisation - multiple start and end times

Hi Anonymous ,

You should be able to do this with a change or two to the measure you have currently. I've created a rough setup but the idea should work the same. 

Keep your time table unlinked, and create a measure like this one

Measure = 
Var _time = SELECTEDVALUE('Time Table'[Time])
Var _activity = CALCULATE(COUNTROWS('Table'), 'Table'[Start]<= _time , 'Table'[Finish] > _time)
Return
_activity + 0

The idea is to look at the current time, then count how many events are active at that time, using CALCULATE to filter the table.

If you add the 'Operating Theatre' field into you rows, turn off 'stepped layout' under row headers formatting and then add this measure to values

That will give you something like this

And then you can format the 1s to show colour and the 0s to be blank, as you have before.

Hope that helps, 

Any problems please let me know.