EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Data Science Data Science Tutorials Power BI learn Power BI Parameters

Power BI Parameters

Priya Pedamkar
Article byPriya Pedamkar

Updated March 28, 2023

Power BI Parameters

Parameters in Power BI

Parameters in Power BI are used to analyze different types of scenarios of the same outcome. We can use a parameter slicer in Power BI we can change the level of analysis either high or low to get the conclusion. It is like doing the What-If analysis in Excel. We can perform any kind of analysis in Power BI as we used to do in Excel, which is exactly based on What-If Analysis. To understand it better, let’s consider a data set of some populations and you want to analyze what is the percentage increase in Men and Women ratio on the basis of location and geographical condition. This seems a little tricky but with the help of population data, we can conclude something.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

How to Use Parameters in Power BI?

To access Parameters in Power BI, go to Modeling ribbon and under the What If section, select New Parameter as shown below.

Modeling Ribbon

If we click on it, we will see the option What-If parameter as shown below. This is where most of the work for Parameters are done.

Power BI Parameters Example

We have a table which contains Sales Data of Medicines. In the below table we have City names, quantity sold in those cities and price of the medicine. With the help of Parameters, we will calculate how much discount could be given to see the changes.

Power BI Parameters Example 1

You can download the workbook used in this example to practice along with us from the below link.

You can download this Power BI Parameters Excel Template here – Power BI Parameters Excel Template

In the following section, we will go through the detailed step-by-step process to create Parameters in Power BI.

  • Step 1: Now to create Parameters in Power BI, first we need to upload this data in Power BI. Go to the home menu ribbon and click on Get Data option to know the list of all the sources as shown below. As our data is in excel, so we will be selecting Excel.

Example 1 (Menu Ribbon)

  • Step 2: This will take us to browse window. Find the file and open it. From the navigator window, select the sheet which we want to use in Power BI and then click on Load.

Example 2 (Navigator)

  • Step 3: Once it is done, we will be able to see the loaded Data tab.

Power BI Parameters Example 3

  • Step 4: Now we will create a table which will show the city and the total sale of those cities. Select Table chart from visualization and drag city name and total price into values.

Example 4 (visualization)

  • Step 5: This will give us the Table in the Report tab.

Power BI Parameters Example 5

  • Step 6: Now we will create a Parameter to see what changes come if we allow to give some discount.

Power BI Parameters Example 6

  • Step 7: Name the parameter as per your choice. As we calculate the price cut off so here also we will be doing it in the same way and we will keep the data type as the Whole Number.

Power BI Parameters Example 7

  • Step 8: Suppose we want to cut the price in the range of 5-10%, then mention the same in the Minimum and Maximum section. And we will keep the Increment as 1. This is for getting 1 unit increment in Min and MAX values.

Power BI Parameters Example 8

  • Step 9: By clicking Ok, it will add a slicer in the Report page as shown below.

Example 9 (Slicer)

  • Step 10: As the slicer is seen in the report page, we will see also see the Cut Off parameter fields.

Example 10 (Cut Off parameter fields)

  • Step 11: These two values are automatically created from DAX by GENERATESERIES and SELECTEDVALUE. To see the formula in created fields in Price Cut Off, just select it.

Power BI Parameters Example 11

  • Step 12: Where GENERATESERIES function syntax says minimum value for cut off is 5, maximum is 10 and incremental value is 1. Same it is with Price Cut off Value field as well.

Power BI Parameters Example 12

  • Step 13: Now we will create a new measure for a price cut off in Sales Table.

Example 13 (New Measure)

  • Step 14: We will name it as Sale with Price Cut Off. You can choose any name here.

Power BI Parameters Example 14

  • Step 15: To get the Sales figure use SumX function. This is used to include a table as well when we have different tables to include.

Power BI Parameters Example 15

  • Step 16: As per syntax, select the name of the table and the column which we need to include for a price cut off.

Power BI Parameters Example 16

  • Step 17: Further in the same formula, insert minus sign followed by the name Sales table’s Total Price.

Power BI Parameters Example 17

  • Step 18: We will include the Price Cut Off Value fields here from Price Cut Off and divide it by 100 in the form of a percent.

Power BI Parameters Example 18

  • Step 19: Now drag the created measure in Sales Table values.

Power BI Parameters Example 19

  • Step 20: The table will look as shown below.

Power BI Parameters Example 20

  • Step 21: After some formatting, the table and pivot will look like as shown below.

Power BI Parameters Example 22

  • Step 22: Now to test the parameters which we have set in Price Cut Off, drag the bar Price Cut Off 7, to see what changes happen. As we can see, the price has been reduced 2 more percent after 5 which was the minimum criteria.

Power BI Parameters Example 23

This is how Parameters in Power BI works.

Note: Power BI Parameters in the report file can also be downloaded from the link below and the final output can be viewed.

You can download this Power BI Parameters Template here – Power BI Parameters Template

Pros of Parameter in Power BI:

  • We can create any type of measure using Parameter.
  • Doing the analysis with the help of Parameters gives multiple types of analysis results.

Things to Remember

  • We can use DAX to create different calculation measures.
  • While creating the new parameters or values, always use New Measure.
  • We can change the Minimum, Maximum and incremental change whenever needed.
  • Parameters in Power BI works on What-If analysis theory.

Recommended Articles

This is a guide to Power BI Parameters. Here we discuss how to use Parameters in Power BI with examples and downloadable template. You may also look at the following articles to learn more –

  1. How to Create Charts in Power BI?
  2. How to Design Pie Chart in Power BI?
  3. Power BI Connections
  4. Power BI SUMX
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Power BI Parameters Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Power BI Parameters Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW