Back to blog
·1 min read

Interactive Functions in Power BI: Beyond the Button

Field parameters, dynamic format strings, and calculation groups — the trio that replaced 80% of my bookmark sprawl.

Interactive Functions in Power BI: Beyond the Button

When a dashboard grows past five bookmarks, you've left BI and entered PowerPoint cosplay. Three Power BI features changed how I build interactivity in 2023, and I keep reaching for them.

1. Field Parameters

The single biggest unlock. Let users swap the measure or dimension a visual references without touching the model.

Sales Metric =
SWITCH ( TRUE (),
    SELECTEDVALUE ( 'Metric'[Metric] ) = "Revenue",   [Revenue],
    SELECTEDVALUE ( 'Metric'[Metric] ) = "Margin",    [Gross Margin],
    SELECTEDVALUE ( 'Metric'[Metric] ) = "Units",     [Units Sold]
)

In practice: one chart, one slicer, three measures. No duplicate visuals on hidden layers.

2. Calculation Groups

If field parameters are about what you measure, calculation groups are about how. YTD, MTD, vs PY, % of total — express each once, apply across every measure.

Tabular Editor remains the way to author these. Build it as a developer artifact, not a click-through.

3. Dynamic Format Strings

Tiny feature, outsized impact. A KPI card that shows "$1.2M" for revenue and "12.4%" for margin — same visual, no string trickery.

Treat the format string itself as a DAX expression. It can branch on the selected metric and stays in lockstep with the value.

What I stopped doing

  • Bookmark navigators with 12 pages.
  • Hidden visuals stacked like Photoshop layers.
  • "View toggle" buttons wired to half a model each.

The user shouldn't care that the chart they're looking at is one visual switching identities. That's the whole point.

Power BIDAXBI