Field parameters in Power BI

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.

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

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

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.

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

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

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

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-

Hope you understand how Field parameters works in Power BI.