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.

[casey_hancock1]

To add one more thing, being able to user sliders to select start/end values for ranges of latitude and longitude could make for some really amazing weather and/or energy data reports.

[casey_hancock1]

This would be an excellent addition to Power BI. I've had several instances where a slider would have really improved the usability of a report. Specifically, I'm looking for something like the sliders in the video above that's a range selector, to pick a min and mix value, to use as a filter. This would be exactly like a timeline visual, but for data types other than time. It would be useful for numbers as well as, perhaps, letters of the alphabet. One example would be to select a range of standardized test scores (set a min and max) to filter data based on those scores.

[pstanek1]

Create measure with parameter. For example: pcena = Calculate( SUM(movement[pcena]); FILTER(movement; movement[date] >= DATE(2016;3;14) && movement[date] <=DATE(2016;4;30))) If I want to change the dates, I will have to create another measure, when I still need an original one. It would be nice to have pcena(start,end) = Calculate( SUM(movement[pcena]); FILTER(movement; movement[date] >= start && movement[date] <=end)). Evaluation would be pcena(DATE(2016;3;14) ,DATE(2016;4;30)).

[scott54]

This is more or less doable today. If you created a table with -100 to 100 (possibly via M if you want granularity), you could leave it with no relationships, and hook up a measure to it: MyValue := MIN(MyHundred[Value]) then simply use [MyValue] in other measures... Small Sales := CALCULATE([Total Sales], FILTER(Sales, Sales[Amount] <= [MyValue])

[robert_kosteck1]

Slider with date ranges allowing to show the changes over time in maps/graphs would be great addition.

[YGruszow]

Suggestions: The slider should have an option to update data in a variable (to use in calculations). There should be an option to show the numerical value/s next to the slider with an option for manual editing.

[kandala_reddy]

Tableau has this feature. our users are asking it for very long time

[Srivastava_Pank]

Yes, It is a required feature for a good BI software and I would expect it from Power BI ASAP.

[fbcideas_migusr]

Slicing on numeric values using a slider could be implemented by changing how the slider renders depending on whether it is used on numeric - or categorical (non-aggregatable, nominal) attributes. If you drag a numeric value in that can be aggregated, the slider could be rendered as a slider.

[Sean0426]

Please seriously consider adding this feature. Tableau took advantage of this feature to laugh at Power BI already. http://www.tableau.com/compare-tableau-power-bi