Power BI + Revit: Promote Parameters into Columns (fast, flexible, visual)
Turn Revit/VIM parameters into real columns you can drag into any visual, no DAX measures required.
⏱️ Chapter markers
00:00 – Goal: make parameters usable as columns
00:07 – Open Transform data; which parameter tables to use
00:19 – Reference Element Parameter → rename to Project Parameters
00:30 – Select 3 columns: Element, Descriptor Name, Quantity (Feet or Meters)
00:51 – Remove other columns
01:03 – Filter descriptors via Text filter → Advanced (OR) (e.g., Area/Volume/System Name)
01:13 – Pivot Descriptor Name → Values = Quantity (Don’t aggregate)
01:29 – Set data types (Decimal Number for numerics)
01:34 – Close & Apply
01:47 – Model view: relate Element Key ↔ Project Parameters.Element (both directions)
02:00 – Report: drag new columns into Matrix (Area, Volume, etc.)
02:21 – Add conditional formatting (background gradient)
02:43 – Use promoted columns to split/group (e.g., by System: none, empty, per-system)
03:04 – Ideas: slice by Fire Rating or other project fields
03:20 – Wrap-up
📚 Learning points
1️⃣ Promote parameters by reference → filter → pivot (no DAX needed).
2️⃣ Pick the right unit column (Feet vs Meters) before pivoting.
3️⃣ After pivot, set proper data types so you can sort/aggregate/format.
4️⃣ Create a two-way relationship (Element ↔ Project Parameters) to use columns across visuals.
5️⃣ Use conditional formatting to make quantities pop in matrices.
6️⃣ Promoted columns can drive grouping/slicers (System, Fire Rating, etc.).
👍 Like • 🔔 Subscribe • 💬 Which parameters do you promote most often?