Power BI: 3 Minute Tips - What If Analysis (Adjustable Goal)

In this tutorial, I'll show you how to use What If Analysis in your report. Specifically, we are adding an adjustable sales goal to be able to input what percent increase we desire over last year's sales.

To enroll in my introductory or advanced Power BI courses:

[johnabram]

@ 1:29, is there a particular reason you used "-12, MONTH" with DATEADD instead of "-1, YEAR" ?

[sravankumar]

what formula use goal, can u write it am not able to see

[marianneblanck]

Hi! do you know if it's possible to reset a What If parameter back to default? Once I publish the report and users start playing with the parameters, the default feature is basically inexistent? Or to assign a value to the what if parameter by clicking a button?

[nboisen]

Quick question... Why is it necessary to add a "measure table" before creating your Last Year Sales measure? Couldn't you make the measure without that table? What am I missing?

[xaratsarhs]

Great video helped me a lot! Could this work for multiple dimensions/categories of the same sales data? ex beverages go up 1, 05% and food 1, 07%? that would be awesome!!