Events
31 Mar, 23 - 2 Apr, 23
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.
In the following video, Sujata demonstrates how you create field parameters and how your report users interact with them.
In the following example, the report reader can dynamically update the bar chart and table by selecting a field in the horizontal slicers above the visuals. Currently, the bar chart and table are measuring COGS and analyzing by Product, based on the reader’s selection in the slicers.
To get started, you first need to enable the Field parameters preview feature.
In Power BI Desktop, go to File > Options and settings > Options > Preview features.
Select the Field parameters.
To create a new field parameter, go to the Modeling tab and select New parameter > Fields.
To build the parameter, provide a name for the parameter and select the fields you want to use. In this example, see the selected dimensions Customer, Color, Category, and Product.
In this dialog, you can drag to change the order of the fields or double-click any of the selected fields to change the display name.
You can also mix and match measures and dimensions within the same parameter. For example, you can use this feature to create a dynamic table, where the columns can be either measures or dimensions.
Once you create a field parameter, you can use the parameter to control the measures or dimensions used in a visual.
You can use the parameter in the field drop zones for a visual. Certain visual properties have restrictions on the number and type of fields that you can use.
From the context menu, you can also choose whether the field parameter shows the values or the display names of the selected field(s).
In the Values box, select the down arrow next to the parameter name and select Show selected field.
If you need to edit an existing field parameter, modify the Data Analysis Expressions (DAX) directly.
For example, if you want to add a new field to an existing parameter, select Shift + Enter to start a new entry. Add a comma between entries, and match the format shown in this example. The number after the comma indicates the order of the fields:
Parameter = {
("Customer", NAMEOF('Customer'[Customer]), 0),
("Category", NAMEOF('Product'[Category]), 1),
("Color", NAMEOF('Product'[Color]), 2),
("Product", NAMEOF('Product'[Product]), 3)
}
For more information take a look at the following articles:
Events
31 Mar, 23 - 2 Apr, 23
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Configure Power BI report filters - Training
Report filtering is a complex topic because many techniques are available for filtering a Microsoft Power BI report. However, with complexity comes control, allowing you to design reports that meet requirements and expectations.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Use parameters to visualize variables - Power BI
Learn how to create your own parameters to imagine and visualize variables in your Power BI reports.
Use grouping and binning in Power BI Desktop - Power BI
Learn how to group and bin elements to ensure the visuals in your reports show your data the way you want them to.
Expression-based titles in Power BI Desktop - Power BI
Create dynamic titles in Power BI Desktop that change based on programmatic expressions, using conditional programmatic formatting.