Field Parameters

Power BI · Data Visualization

Theory

Field parameters let report readers choose which measure or column a visual uses. You create one with Modeling → New parameter → Fields, pick the fields to include, and Power BI generates a small calculated table plus a slicer. Put the parameter on a visual's axis or values, and when the reader picks an option in the slicer the visual switches to that field.

For example, a parameter 'Metric' with [Total Sales] and [Total Qty] placed in the X-axis of a region bar chart lets readers flip between sales (North ₹3,200, West ₹2,400, South ₹600) and quantity (North 6, West 3, South 1) without a second chart. A parameter of columns, such as Region, Category and City, lets them change how the chart is grouped. The generated table uses NAMEOF to reference each field, and the third value controls the order.

Why we use it

Without field parameters you need a separate visual or bookmark for every metric or grouping. Parameters keep the page clean and let readers explore on their own.

When to use it

Use them when readers ask for the same chart by different measures or dimensions. For a numeric 'what-if' input such as a discount percentage, use a numeric range parameter instead.

How it works

  1. Readers want one chart, many metrics
  2. Modeling → New parameter → Fields
  3. Choose the measures or columns to offer
  4. Place the parameter on the visual and add its slicer
  5. Reader picks an option? Yes: Visual switches to that field. No: Default field is shown.
  6. One flexible visual

Syntax

Modeling → New parameter → Fields → add fields → (Add slicer to this page)
Generated DAX:
Parameter = {
    ("Label", NAMEOF(<field>), <order>),
    …
}

Example

Metric = {
    ("Total Sales", NAMEOF('Sales'[Total Sales]), 0),
    ("Total Qty", NAMEOF('Sales'[Total Qty]), 1)
}

// Bar chart: Y-axis Sales[Region], X-axis Metric
// Slicer on Metric: choose 'Total Qty' → North 6, West 3, South 1

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic