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.