Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Dynamic Parameters for What if analysis

[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.
Status: Completed
Comments
niekv
Regular Visitor
A free form input box would be best for all situations, where users can enter a number (example value: 1, 5.55, 2000, 24000), and use this number within an expression (units * example value = new sales)
mtstewart17
Advocate I
I agree with others that an input box that can be used in DAX formulas would be the best and most versatile solution, but hopefully they make they adjust the slicer to act in a similar way.
arvind_yadav
New Member
Hi Will Thompson, Its great to see what if analysis in Power BI . Please Resolved "What If" analysis query.
tbecks
Microsoft Employee
What about passing a parameter into an R visual?
samir_mammadov1
New Member
Hi. Is it possible to include "What if" analysis tool in future versions of Power BI? I think it will be great present for Power BI guys.
ahines
Advocate IV
When will this be available?
priya_george
New Member
When will this be made available? Waiting..
mdc2
New Member
When will this be available?
pwickwire
New Member
You provided the WHAT IF parameter in the August 2017 release. It looks great. HOWEVER, it is not supported by SQL Analysis Services cubes (OLAP or TABULAR). PLEASE update this feature to work in Reports that are hitting SSAS data sources
Niels1
New Member
Nice feature, but will this be available for live connections to Analysis services cubes also?