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.

[germanhenrique1]

It would great if we can save different versions or scenarios of a what if analysis. Sometimes I think power bi should work in same way that sharepoint`s control versión whit extract from the repository and insert to the repository, and write a comment about the change also. It should be a sync instance between the power bi and power desktop when we edit a report in power BI service.

[mtran123]

Great that this feature has been added! This tool is very useful when doing what if analysis with percentage values however not with large numbers. For example I would like to see how the cost of a project (ranging from $1,000-$1,000,000) will affect NPV. Currently, the visual tool will not support that large of a range. Also, when removing the slider option, the manual input seems to bug out a lot.

[JorgeDiaz]

We need this on SQL SSAS connections

[bharat2]

I am trying to create a what if type analysis report in power BI Desktop ( Free version ) however not able to create it as the new parameter what-if button on modelling tab is disabled. Could you please help know me how it can be enabled?

[jose_a_pintor1]

Hi everyone It would by useful if we could have the possibility to input directly in the slicer eg:a diferent percentage for each item for a list of itens of a certain dimension such as : category or region or what else... Eg slicer: Dimension: category NAME VALUE (input manual by end user) PCs 5% PRINTERs 7,5% IPADS 0% IPHONEs 2,5% .....and then use each of those percentages in a calculated measure to visualization. What do you think about it? José Pintor