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.

[nishalit]

Hi everyone! I'm pleased to say this is available in the August update of Power BI Desktop. You can create a table that is bound to a slicer to select a value, and use that value in your calculations. At the moment it's not supported in Live Connect mode over SSAS models - if you have a requirement for that scenario please vote here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20558389-enable-what-if-parameters-with-analysis-services

[ChasinInsight]

This is a definite closer for our competition. I often hear we bought tableau once the business saw the slider demo.

[binhcao]

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.

[philgad]

I can't understand how we can help decision making without this functionnality. At the begining of the previous decade I used Xcelsius allowing filtering with sliders and the ability to save or load scenario.

[philgad]

I would add: The ability to map range slider on each column The ability to save & load scenario

[tychogrouwstra]

Currently pivot reports allow adding slicers to filter inputs... but for numerical inputs the slicers just aren't quite as intuitive as a numerical slider would be. I hope something like this could be added as well!

[zach_fransen]

This would be huge, especially for dates so users can watch changes over time in a fluid way.

[abbas_141]

What-If analysis feature is available in Tableau...

[mpa1]

And it would be even better if dragging sliders made data change "live" without having to release the mouse button. That would be an awesome feature.

[xiaohou20042003]

Use parameters (such as selected values from slicer) in Filter in CALCULATE function. Currently filter in CALCULATE can only take hardcoded, fixed values in evaluating booleans.