Use Case · Property managers, REIT analysts, portfolio leads

Best Power BI Visuals for a Real Estate Portfolio Dashboard

The best Power BI visuals for real estate portfolio — occupancy heatmaps, NOI bullets, rent roll flow, lease expiration Gantt.

Real estate portfolio dashboards span many properties, many unit types, many tenants, and long time horizons — every property has a lease-expiration calendar, a rent roll, a capex plan, an occupancy pattern. Native Power BI visuals handle aggregate numbers but not the portfolio-level pattern-seeing you need.

VizForge generates portfolio-shaped visuals: heatmaps for occupancy grids, Gantt for lease-expiration schedules, Sankey for tenant flow, bullet charts for NOI attainment. Below is the cut list.

Recommended visuals

Heatmap
Occupancy grid: property × month, values = % occupied. Spot seasonal patterns and chronic vacancies.
Gantt Chart
Lease expiration schedule per property. See concentration of rollover risk.
Bullet Chart
Per-property NOI vs. budget and prior year.
Sankey Diagram
Tenant flow: new leases → expansion → exits. Shows retention and turnover patterns.
Waterfall Chart
NOI bridge: last year → rent growth → vacancy → opex → this year.
KPI Card
Top-of-dashboard portfolio KPIs: total NOI, weighted occupancy, cap rate, WALT.
Treemap
Portfolio composition: asset class → market → property, sized by value.

Typical DAX measures

Occupancy %

Occupancy =
    DIVIDE(
        SUM( Units[Occupied SqFt] ),
        SUM( Units[Rentable SqFt] )
    )

Weighted Average Lease Term (WALT)

WALT Years =
    VAR TotalWeight = SUM( Leases[Annual Rent] )
    RETURN DIVIDE(
        SUMX(
            Leases,
            Leases[Annual Rent] *
            DATEDIFF( TODAY(), Leases[End Date], YEAR )
        ),
        TotalWeight
    )

Net Operating Income (NOI)

NOI = SUM( Revenue[Amount] ) - SUM( Expenses[Amount] )

Example VizForge prompts

Example VizForge prompt

Heatmap: property (rows, 30 properties) × month (columns, last 24 months), values = % occupied. Green for 95%+, yellow 85-95%, red below 85%.

Example VizForge prompt

Gantt chart of lease expirations. Swimlanes = property, bars = lease terms, color by tenant type. Overlay a vertical 'today' line. Show only leases expiring in the next 36 months.

Example VizForge prompt

Waterfall chart of NOI bridge from last year to this year: rent growth → vacancy impact → opex inflation → capex amortization → NOI this year. Green bars for favorable, red for unfavorable.

Build your a Real Estate Portfolio Dashboard

Free plan: 3 visuals per month. No credit card required.

FAQ

Can I show portfolio geography on a map?

Yes — VizForge generates custom map visuals. Prompt for 'US map with properties plotted as circles, size by NOI, color by occupancy band'.

How do I handle mixed-use or multi-asset-class portfolios?

Use a slicer for asset class and let the visuals filter. For side-by-side comparison, prompt for small-multiples by asset class.

Can the Gantt show lease dependencies or anchor-tenant relationships?

Yes — bring a Relationship column and the Gantt draws connecting arrows.

Different use case?

Browse all VizForge use cases →

Your next visual
ships in 4–10 min.

Sign up free. 5 credits to generate your first visuals on us. No credit card required.