Home » Power BI » Field parameters in Power BI

Field parameters in Power BI

Field-Parameters-PowerBI

In this blog you will understand all about “Field Parameters” feature in Power BI.

Microsoft Power BI team released Field Parameters feature in May-2022 updates. Using this feature you can dynamically change the column names & measure values in the visuals.

You can enable this feature from Preview feature option-

File > Options & Settings > Option > Preview & Features > check “Field Parameters” option

Scenario 1 – Change column name dynamically in the visual

Step-1: Under Modeling Tab > Click on New Parameter > Choose Fields.

Field Parameters

Field Parameters



Step-2: Parameters window will appear, now choose the columns to whom you want to change dynamically.

Add columns to field parameters

Add columns to field parameters

Step-3: Now add one matrix visual and drag Parameters in Rows, and add some values as in values section.

Field Parameters Example-1

Field Parameters Example-1

Step-4: Now choose the columns name from Parameters slicer. As you can see below screen shot, columns are dynamically changing in the visuals based on selection.

Field Parameters Example-2

Field Parameters Example-2

Step-5: You can also choose the multiple column names from slicer, see the below screen shot-

Field Parameters Example-3

Field Parameters Example-3

Scenario 2 – Change measure values dynamically in the visual

Step-1: Create two measures-

Total Gross Sales = SUM(financials[Gross Sales])
Total Unit Sold = SUM(financials[Units Sold])

Step-2: Go to the Modeling tab > Click on New Parameter > Choose Fields.
Step-3: Add measures in the field parameters

Add measure in field parameters

Add measures in field parameters



Step-4: Now Drag Parameters into Values section of Matrix and add some columns into Rows section.

Change Measure value dynamically

Change Measure value dynamically

Step-5: Choose the measure from slicer which you want to see in visuals.

Scenario 3 – Change both column & measure values dynamically in the visual

For this you can add two parameters separately like one for columns & other for measures.

After that add both parameters in rows & values section of visuals, see the below given screen shot-

Fields Parameters in Power-BI

Fields Parameters in Power-BI

Hope you understand how Field parameters works in Power BI.

Leave a Reply