Lesson Goal (00:20)
The goal of this lesson is to learn how to use a What If parameter in a visualization.
Creating the What If Parameter (00:28)
A What If parameter is a field in a dataset that can have a variety of possible values. These values are usually adjusted using a slicer. What If parameters can be used when you want to study the impact of different possible values for a field. In our dataset, we use a What If parameter to analyze the effects of changing the percentage of each sale paid to the salesperson as a commission.
We can create What If parameters by selecting the Modeling tab, and New Parameter. When creating a parameter we specify the data type for the parameter, the minimum and maximum values, and the increment between possible values. We can also choose to add a slicer to our report which can be used to select a value for the parameter.
After we create the parameter, a new table is added to the model containing two fields. One field contains all the possible values for the parameter, the other contains the currently selected value for the parameter.
Using the Parameter in a Chart (03:32)
In order to use a What If parameter in a chart, we need to create a measure that uses the currently selected value for the parameter. A measure is simply a formula that we can add to visualizations. In our example, we create a measure that multiplies total revenue by the percentage of revenue not given out in commission. This helps us identify the total revenue after commissions are paid.
Once we’ve created a measure, we can use it in visualizations like any other field. If we adjust the slicer for our parameter, then the value of the measure will also adjust and the visualization will change accordingly. In our case, we create a bar chart showing the revenue for each month after commission. As we adjust the commission percentage using the slicer, this chart adjusts automatically.
hashtags
#powerbi #dataanalytics #datavisualization #powerbitutorials #powerbideveloper #powerbipro #powerbiforbeginners #learnpowerbi #powerbiservice #newskills #dataanalysis #datascience #dataanalyst #powerquery #powerpivot
Tags
Power Bi for Beginners
Power Bi Refresher
Power Bi Free Lancing Skills
Power Bi Tutorial
Power Bi Learn for Free
Power Bi dashboard
Power Bi Full Course
Power Bi Systematic Course Outline
Power Bi vs Tableau
- How to Perform What if Analysis | What if Parameters in Power Bi - Lesson 12 (Learn Power Bi) ( Download)
- WHAT IF PARAMETERS in Power BI I Forecasting Power BI Search Trends in 2021 ( Download)
- Power BI Tutorial (26/50) - What If Analysis in POWER BI ( Download)
- Scenario Analysis in Power BI - Using What If Parameters ( Download)
- What-If Analysis Using PowerBI ( Download)
- What IF Analysis in Microsoft POWER BI | Narration | Explain the Increase | DAX - Calculate DateAdd ( Download)
- What If Analysis Power BI ( Download)
- 'What If' Parameter Feature Review - Power BI & DAX ( Download)
- Introduction to Power BI Preview Module 05C Creating the Data Model What If Parameters ( Download)
- 'What If' Sensitivity Analysis in Power BI using DAX - Advanced Technique ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Power BI - What-If analysis &L Demo ( Download)
- PowerBi & DAX - Using Parameters for Discount Scenario Analysis ( Download)
- PowerBI What - If Analysis ( Download)
- Excel Solver & Goal Seek Tutorial ( Download)
