[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.
86 Comments
- 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
Microsoft Employee
This is a definite closer for our competition. I often hear we bought tableau once the business saw the slider demo. 
binhcaoSo 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.- 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.
- I would add: The ability to map range slider on each column The ability to save & load scenario
- 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_fransenAdvocate I
This would be huge, especially for dates so users can watch changes over time in a fluid way.- What-If analysis feature is available in Tableau...
- 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.
- 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.
Recent ideas
Visual header icon improvements: Options for permanent visibility on per-icon basis, weblinks etc.
Current problem: Visual header icons like the 'Help tooltip' icon are potentially incredibly useful, however they rarely pass muster for our needs as so many of our report owners/authors insist on th...
