Real Estate Property Portfolio Power BI template

Layout

Header band with logo, 5 KPIs, tall NOI map left, lease-expiry columns + occupancy bars + rent roll right

Page size

1280×720 px (16:9, Power BI default)

Theme

Slate Executive

1. 1

   Unzip to a short path and open the .pbip

   Extract the zip to a short local folder such as C:\PBI (Windows limits project paths to 260 characters, and Desktop can't save a project straight to OneDrive or SharePoint), then double-click the .pbip file or use File → Open in Power BI Desktop. Microsoft still lists projects and TMDL as preview features (as of Nov 2026): if Desktop won't open the project, go to File → Options and settings → Options → Preview features, tick “Power BI Project (.pbip) save option” and “Store semantic model using TMDL format”, then restart Desktop.

2. 2

   Select Refresh once

   The project ships without the local data cache (.pbi/cache.abf), so Desktop opens the full model definition without data. Select Home → Refresh: every table is built from values written into its Power Query step, so there is no data source to sign in to.

3. 3

   Save as .pbix or connect your data

   Use File → Save as to keep a single .pbix file, or open Transform data and replace each table's Source step with your own query, keeping the column names so the measures and visuals keep working.

Passing Rent =
SUM ( Leases[Annual Rent] )

Rent per m² =
DIVIDE ( [Passing Rent], SUM ( Leases[Area] ) )

WAULT (years) =
DIVIDE ( SUMX ( Leases, Leases[Annual Rent] * Leases[Years to Expiry] ), [Passing Rent] )

Rent Expiring in 12 Months =
CALCULATE ( [Passing Rent], Leases[Years to Expiry] <= 1 )

Net Operating Income =
SUM ( 'Property Month'[Rental Income] ) - SUM ( 'Property Month'[Operating Costs] )

Occupancy % =
VAR LastMonth = MAX ( 'Property Month'[Date] )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( 'Property Month'[Occupied Area] ), 'Property Month'[Date] = LastMonth ),
        CALCULATE ( SUM ( 'Property Month'[Lettable Area] ), 'Property Month'[Date] = LastMonth )
    )

• How much net operating income does each property and city produce?
• How much rent expires in each of the next five years?
• Which property types are carrying the most vacancy?
• What is the weighted average unexpired lease term (WAULT) of the portfolio?

• Slot: Occupancy

  KPI Card

  Executive dashboard KPI row (revenue, customers, NPS, churn)

1. 1

   Download the background

   Take the 1920×1080 PNG for a new page in a Fluent 2 report (the default size for new pages), or the 2× PNG (2560×1440) for sharp text on a 1280×720 Classic page. Power BI scales the image to the canvas.

2. 2

   Set the canvas background

   Format page → Canvas background → Browse. Set Image fit to Fill and transparency to 0%.

3. 3

   Import the theme

   Design ribbon → Import theme (in the Power BI service: View → Theme pane), then pick the downloaded JSON. Data colours and fonts now match the design. Older Desktop builds: View → Themes → Browse for themes.

4. 4

   Place your visuals

   Size each visual to the positions above with background and border off, or open the PBIP project where they are already placed.

• Dashboard job

  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…

• Team

  Power BI for finance

  Variance bridges, balance-sheet smalls, scenario sliders — the finance visuals Power BI's native waterfall and cards don't cover.

Want the headline numbers to look like cards rather than plain values? Browse the KPI card gallery or build your own in the SVG measure builder.

• 

  Workplace Space Utilisation

  Real estate & workplace

• 

  Hotel Revenue Management

  Hospitality

• 

  Payroll, Overtime & Absence

  HR & people