How to Use Field Parameters in Power BI
A field parameter in Power BI is a special table that holds a list of measures or columns. You connect it to a slicer, and when the user picks a value from the slicer, the visual updates to show the selected measure or dimension. This lets you build one chart that can display Revenue, Cost, or Margin depending on the user's selection, instead of building three separate charts.
Field parameters in Power BI let report users switch between different measures or dimensions on a visual using a slicer, making one chart do the work of several.
What Field Parameters Are
A field parameter is a Power BI feature that creates a special table holding references to your measures or columns. When you connect a slicer to this table, the slicer controls which measure or column a visual uses. The visual itself does not change: its configuration points to the parameter, and the parameter resolves to whichever item the user has selected. From the user’s perspective, they click a button and the chart updates instantly.
A Practical Example
Imagine a sales performance chart that your finance team wants to show as either Revenue, Gross Margin, or Operating Cost depending on what they are discussing. Without field parameters, you build three charts and hide/show them with bookmarks. With field parameters, you build one chart, add a three-option slicer, and let users switch. The same principle works for dimensions: one chart showing sales by whatever grouping the user picks (Region, Product Category, Sales Rep) from a slicer. Pair this with dynamic colour coding and you get a highly interactive dashboard from minimal visual complexity.
How to Create a Field Parameter
Field parameters are still a preview feature in some versions of Power BI Desktop, so you may need to enable them first under Options and then Preview Features. Once enabled, go to the Modeling tab and click New parameter, then Fields. Name the parameter and add the measures or columns you want to include. Power BI creates a DAX table behind the scenes and automatically places a slicer on the canvas. Drag the parameter’s Name field into the axis or values area of your visual, and the connection is made.
Connecting Parameters to Slicers and Visuals
The auto-generated slicer works immediately, but you will want to format it. A tile-style button slicer communicates the available options more clearly than a plain list. You can apply the parameter to multiple visuals on the same page: all of them respond to the same slicer. This makes it straightforward to build a KPI summary page where every chart switches metric simultaneously. For adding KPI indicators that respond to the same selection, see Power BI KPI Indicator.
Limitations to Know
Field parameters have some constraints. You cannot mix measures and columns from different tables in a way that creates ambiguous relationships. The slicer is always single-select by default; multi-select is possible but requires more careful visual configuration. Field parameters also increase the complexity of your data model slightly, so use them where users genuinely need the interactivity rather than for every chart. For simpler toggle scenarios, bookmarks are sometimes a more straightforward alternative.
Our tip: Give each option in your field parameter a short, action-oriented label such as “Revenue”, “Margin”, and “Cost” rather than technical measure names like “[Gross Revenue Total]”. The label is what users read in the slicer, so make it immediately clear what they are selecting.
Frequently asked questions
Can I use field parameters to switch dimensions as well as measures?
Yes. Field parameters support both measures and columns. You can create a parameter that lets users switch the axis of a chart between Product Category, Region, and Sales Rep. When the user selects Region from the slicer, the chart groups data by Region. When they select Sales Rep, the same chart shows individual sales rep performance. This is particularly useful for exploratory dashboards where users want to slice the same data along different dimensions.
Do field parameters work with calculated columns?
Field parameters are designed for measures and regular columns in your model. You can include calculated columns in a field parameter, but you cannot include measures computed from other measures inside the parameter definition directly. The parameter table itself contains DAX expressions that reference your existing measures and columns, so the measures must already exist in your model before you add them to the parameter.
What is the difference between a field parameter and a What-If parameter in Power BI?
A What-If parameter creates a numeric slider that generates a single scalar value you can use in DAX calculations, for example to simulate price changes or growth rates. A field parameter creates a list of measures or columns that users can select to change what a visual displays. They solve different problems: What-If is for scenario modelling, field parameters are for dynamic metric or dimension switching.
Can I rename the options shown in the slicer for a field parameter?
Yes. When you create the field parameter, the names you see in the slicer come from the display names you assign to each field in the parameter dialog. You can edit these names directly in the parameter's DAX table definition. Open the parameter table in the Data view, find the DAX expression that defines the table, and modify the display name strings. Changes appear immediately in the slicer.