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.

[alan_walnoha]

We also would like to have a slider for these What If analysis.

[hacun]

I dont believe it doesnt exist in this century 🙂

[tarek_zeid]

I believe it's time for interactive reports, to give the ability to build a GUI interface for what if scenarios based on end-user input and stored data, currently it can be done by applying some filters only, but it would be much more useful if you allowed end-user to write values and get results.

[ivan_tamburic]

It would be also great if we had ability to bind user file (excel, txt, csv) to parameter, directly on reports. e.g. Filter report using file that contains customer IDs.

[mark_walter]

I think this is already possible in a Dax measure that references a disconnected table that holds your parameters. Write your IF statement to look to the 'max' number option selected in your parameter table. If max=1, then ..., if max=2, then ... that way, when you slice to 1, you get a different variable calculated in your result. Choose 2 and your measure changes again.

[rpsinha1987]

Hi Charles, For the existing parameter feature, you have to set the parameter value before hand and it remains constant until you change and refresh your model again. The request here is to create dynamic parameters that you can adjust without the need to refresh the model. Also, the ability to use this parameter value in creating custom columns (calculations), or measures. And the ability to expose this parameter in form of a text box or a range slider so that you can use this on your report and make changes to the value affecting the calculated fields/measures. Please let me know if additional information is required.

[shankar_patil1]

https://javierguillen.wordpress.com/2012/04/22/what-if-analysis-at-the-right-level-of-granularity-in-powerpivot/ This describes what we need also; thanks to whomever shared. A slider for different scenarios would be a great enhancement.

[chass]

Can you please explain how the current parameter implementation doesn't solve this?

[florian_seuret]

hello, we would like to have this possibility. To change one or some parameters to look the impact of some changes. What will be my charge if some taxe goes for 1 to 1.2 ? Thank you to add this !

[DPlankenhorn1]

I would cast my vote to add this functionality as this would be akin to defining a named cell value in Excel and referencing the Named Range in an Excel calculation. This facilitates changes to key calculation values that may change over time.