Make a What if Analysis using Parameter.

Make a what if analysis using parameter.
Explanation
1. Here we are going to analyze the sales, if the sale value increased by 0 to 100 then what happens; we are going to predict the sale value.

2. Drag Order Date into Columns.

3. And drag Measure Values into rows.

4. Create the parameter for 0% to 100%

Make a what if analysis using parameter.
5. Now we are going to create a calculation field for the Parameter. As shown below.

Make a What if Analysis using Parameter.
6. Now drag measure names into filter self and select sales and Calculation field. then click on apply and then click on OK.

7. Drag the measure names into color self at marks card level. After that right click on that and select the sort option and give the sorting as shown below.

Make a What if Analysis using Parameter.
8. Now check the parameter is working fine or not. The final result looks like below.

Make a What if Analysis using Parameter.

Leave a Reply

Your email address will not be published. Required fields are marked *