Introduction of Field Parameter in power bi
Field Parameter is the new modeling feature in Microsoft Power BI Desktop which can be used to display dynamic columns or measures in Visuals. Let’s consider a scenario, suppose you are making a report for sales team, and you must prepare a bar chart where you are displaying the number of customers by age group, type, and stores. There is a slicer that has these options like Store, Type, and Age so whenever the user is selecting Store from the slicer then the bar chart should display the number of customers by stores. In similar way when user is selecting the Age then it should display values in the bar chart by Age group. So how we can achieve this functionality? So, here comes the field parameter in picture.
- create a Field Parameter
Note
As this is a preview feature, so we must need to enable this in Power BI Desktop.
Step 1:
Click on file Menu and then click Options and Settings and then click on Options.
Step 2:
Go to Preview features option in the Options Dialog box and then check mark the Field Parameter and then click OK.
Step 3:
Click on Modeling ribbon, click on New Parameter Dropdown Menu and then select Fields.
Step 4:
Enter the Name for your field parameter in the Name Textbox.
Drag and drop the columns which you want to display in the bar chart.
Click on Create button.
After the above step one slicer will be added to the page.
Step 5:
Add the bar chart on the canvas and then from the fields section there will be a new table which is named as the field parameter which you have created in the last step. Select the “Column View” column from that table and add in X-axis of bar chart and sales from the financials table in Y-axis to display the sales of products.
After all these steps we can now display the sales of products and country wise sales and their total unit sold in the single visual with different options.
For any Help or Queries Contact us on info@crmonce.com or +91 9014146800
We have started a new online retail store 
Please Visit.
