Dynamic Parameters for What if analysis

[rpsinha1987]

[Will Thompson] I've just merged a couple of very close scenarios, which all have similar great ideas! Something we're considering for the future, so I'm keen to hear your feedback on this. I like this core scenario of a numeric value that is bound to a slider control, and can then be used as part of some expression. - In a sales report, I can adjust a '% increase' slider to see what impact a small change in revenue might have had on my sales. - In a mortgage calculator, I can change the % rate, borrowed amount and term to see projected repayments - In a quota report I might change a 'Opportunity confidence' control to see the likely bonus I could earn at the end of the year. Please, keep voting and help us prioritize this! Original suggestions follow: So this scenario brings what-if-analysis to the visualization without changing the underlying data source. Let's say I have a table that has numeric values (integers, floating values, etc.). I created a chart (column, line, etc.) visual of that table data. Then instead of using SUM, AVG, COUNT, DISTINCT COUNT, I now can use a math expression applied to the numeric value (say I want to see what my chart looks like if I increase sales by 10%). Then I would see the new column in my table (calculated column with new values). I can now add that new column to the chart and graph that, labeling that as 'if sales increased by 10%' to show how that would compared to the actual numbers I see.

[phoflack]

This is certainly a must have!

[ehkhan]

This is a BI functionality that should be available in BI tools.

[robertbain]

Please add the ability to have a user defined parameter tables within Power BI so we don't have to jump through so many hoops to import user defined parameters.

[ameyan123]

This is something we are desperately looking for in this tool. This will allow us to see how the visuals are affected by changing the factors and help us in identifying the correct threshold for our business needs.

[saurabh3]

This is an essential feature requirement for a brilliant BI software.

[filip_vandekerc]

Just confirming what is mentioned by my fellow commentators: a must have, a kernel feature to allow simulation and what-if analysis, essential to making Power BI a true business decision tool.

[morgan_collins]

Adding variables which could interact with DAX and dashboard/report items would be helpful for several reports and sensitivity analysis. I.e. a dial which can be moved by mouse which changes a value from -100 to 100, which is linked to a variable which interacts with measures/other calculations, allowing for those who view a report to adjust a sensitivity etc. on the fly.

[KRIMA-IN1]

Power BI does not have options to create Parameters, and calculated fields that inturn use the user entered parameters in reports. Which is cool in Tableau

[info6]

There is a workaround for this: http://www.agilebi.com.au/perform-what-if-analysis-power-bi/ Agree that it should be added as a built-in feature.

[etraveria]

Yes! Please build in some what-if functionalities!