Note: Please click on the headline to open the post in full screen
What is a field parameter in Power BI?
Field Parameters is a feature that enables users to toggle between different fields or measures within a data model. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.
Why should we use field parameters in a report?
This feature helps report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.
How to create a field parameter?
Step 1: Enable Field Parameter in Preview Features
In Power BI Desktop, go to File > Options and settings > Options > Preview features.
Select the Field parameters.
Restart your Power BI Desktop to access this functionality.
Step 2: Create a new field parameter
Go to the Modeling tab and select New parameter > Fields
Step 3: Add fields from tables
To build the parameter, provide a name for the parameter and select the fields you want to use. In this example, I have added ‘Sub Category’ and ‘Sub Region’ fields.
Make sure to check the "Add slicer" box highlighted below. This will automatically place the slicer on the report page.
Now, we can dynamically change the X-axis between 'Sub Category' and 'Sub Region' in the same visual. Refer to images 1 and 2 below.
Here's an example that explains the field parameter for measures. It allows us to easily change the measure in the visual. Refer the images below.
we can also combine the measures and dimensions within the same parameter. Refer the following example.
