Bi what if analysis

Specify the Minimum, Maximum, and Increment values. You can also specify a Default value if you would like. The Add slicer to this page check box will automatically create a special kind of slicer that is used to select a single value for your what-if analysis. Once you click OK, a calculated table will be created based on your input values. The table is created with no relationships to any other table. Also, a calculated measure was created in the new calculated table.

This is the measure we need to reference in order to make our what-if calculation dynamic. Not only can you make better and more informed decisions by changing assumptions and observing or estimating the results, you are also better able to do it faster and with less risks. The ability to perform a what-if analysis is an important feature of any BI tool and the August release of Power BI introduces this ability.

Each agent has a commission structure based on percentage of sales goal achieved. After importing this source into Power BI, we can create a simple dashboard allowing us to filter by sales agent and see the sales performance of each one of our agents by month. You will notice that we do not have an actual sales goal or target yet. We will supply one using the new What If parameter in power BI. If you've already registered, sign in. Otherwise, register and sign in.

Power BI. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Search instead for. Did you mean:. Labels: How To. Top Kudoed Posts. Clicking this button brings up a window where you can specify the attributes of the parameter.

Along with a name, you can provide the data range of available options to select. Choosing this data range is the key to how the parameter works. The end user will still view the parameter as a truly open-ended What-If question, but Power BI will treat their selection as if they simply filtered the underlying mini dataset of values. Indeed, the input window even has a checkbox that lets you add a slicer to the page upon creating the What-If parameter.

The increment you specify in the setup window will determine the sensitivity of the slider, so if you want users to choose between a wide range of data, use a larger increment. For example, if the parameter represents a percent change then it might multiply an existing calculation. If it represents a nominal change, it might just be added to an existing measure.

At Kenway, we have found What-If parameters immensely helpful with the forecasting process. Having built out our internal reporting suite in dynamic Power BI dashboards, we can rapidly pivot from viewing best case and worst-case scenarios when planning for the next months. For instance, our revenue forecasting is built bottom-up from our internal data based on projects we have already won and entered into our ERP system.