Advocate IIIUnit lifecycle on the BIM model
Every unit in a building has a commercial life of its own: vacant, reserved, for sale, sold, rented, back under maintenance. That history usually lives in a spreadsheet, far away from the drawing everyone actually looks at.
This report puts it back on the model. It covers a 28-unit mixed-use building — residential, offices, retail and a restaurant across five levels — and tracks every unit from January 2023 onwards.
Five pages:
Overview — the numbers first: 12 units on the sale side, 16 on the rent side, broken down by vacancy and status. Underneath, every status change plotted over time, one line per unit, split between commercial and residential. You can see a unit go For Rent → Rented → Vacant → For Rent and read how long each leg took.
History 2D — the floor plans, with each unit coloured by its status on the date you pick. Move the slider and the plan repaints.
History 3D — the same timeline on the 3D model, filtered by contract type and level, with the occupancy mix next to it.
Latest – Rent and Latest – Sale — the current picture on each side of the business: what is still available, what is gone, and where it sits in the building.
The model comes into Power BI through Vcad, so geometry and unit properties arrive as tables you can relate to anything else — here, the status history. Selection works both ways: click a row and the unit lights up in the model, click the unit and the tables filter.
The data is fictional. The workflow isn't.
One question, since the report reads history in two different ways: do you get there faster through the status lines on the Overview, or through the slider repainting the plan? I keep changing my mind depending on who I'm showing it to.
