Field Parameters in Power BI: dynamic switching without duplicating visuals

Introduced in May 2022, Field Parameters are one of Power BI's most requested features. They let a user dynamically switch the measure or dimension shown in a chart, without creating duplicate visuals or complex DAX code.

Create a measure Field Parameter

Go to Modelling → New Parameter → Fields. Add the measures you want to make selectable:

Selected Measure = {
    ("Sales",  NAMEOF('fSales'[Total Sales]), 0),
    ("Margin", NAMEOF('fSales'[Margin %]),    1),
    ("Qty",    NAMEOF('fSales'[Quantity]),    2)
}

Power BI automatically creates a calculated table and an associated slicer.

Use the parameter in a visual

On the chart's Y axis, drag Selected Measure[Selected Measure Fields]. When the user selects "Margin" in the slicer, the chart displays the margin measure.

Dimension Field Parameter

It also works for the X axis — let the user choose between analyzing by Region, Category or Period:

Selected Dimension = {
    ("Region",   NAMEOF('dRegion'[Name]),        0),
    ("Category", NAMEOF('dProduct'[Category]),   1),
    ("Period",   NAMEOF('dDate'[MonthYear]),     2)
}

Limitations to know

• It does not work in matrix tables for rows — only for columns.
• Conditional formatting based on a specific field may not work correctly when the field is dynamic.
• The sort column must be added manually to the parameter if you want to control the sort order.

Conclusion

Field Parameters drastically reduce the number of pages in a report and improve the user experience. Instead of 6 identical charts with different metrics, you have 1 chart with a slicer that gives control to the user. Fewer pages, more focus, more professional reports.