Home Tab in Query Editor: "Manage Parameters" option in home tab of query editor in Power BI: Lesson-7 P-16
"Manage Parameters" option of query editor in Power BI: Lesson-7 P-16
In Power BI, "Manage Parameters" is a feature that allows users to create and control parameters in their reports.
Options of "Manage Parameters"
Manage Parameters: This option allows users to view, create, edit, and delete parameters in a Power BI report. Parameters act as dynamic variables that users can use to filter data, customize visuals, or perform other actions within a report.
Edit Parameters: Within the “Manage Parameters” section, users can select individual parameters to edit their properties. This includes editing the data type, setting default values, specifying allowable values, and adjusting other parameter-related settings.
New Parameters: Users can create new parameters from scratch using the "New Parameter" option. When creating a new parameter, users specify its name, data type, default value, and any other relevant settings. It allows users to further customize their reports and make them more interactive by adding dynamic parameter values.
Overall, the "Manage Parameters" feature in Power BI gives users flexibility and control over how they interact with their data, enabling them to create more dynamic and interactive reports.
Lab Work of "Manage Parameters"
"Manage Parameters" Menu
1:- Manage Parameters
- Set parameters on table
- Select required column
- Home -> Manage Parameters -> Manage Parameters
- then...
- after passing parameters
you have
- Now check the parameters to apply this table
- click on city heading
- Click on Text Filter
- Click on equals... option
- Select Parameter option
- Click OK button
then you have
after OK you have
We can also edit parameters:
Method-1:
- Home --> Manage Parameters --> Edit Parameters
- Write new required value like Gujrat
- Click OK
now apply this changed value parameter
Then you have
and you have dashaboard
- after change parameter's value which is Gujrat
Method 2:
We can also change parameter value
- Click Here
Final view
We can also add a list in Parameters
- click on list and select required value
- Home --> Manage Parameter --> Manage Parameter
Use list: (List appear in Current Value)
1st of all click here
we can ctreate more than one (Multiple Parameters)
- Home --> Manage Parameters --> Manage Parameters
- Click on New
- Write Name
- Write description (optional)
- so on...
first of all Click here
here are two parameters
then you have result
Dashboard according to Parameters
You have more options when you apply Parameter value on table
A:- Options(Number Filter):
B:- Options(Text Filter):
you can use every option as you required like Equals..., Does Not Equal... etc. etc
Thanks:
