Dynamic Parameters for What if analysis
Can we have dynamic parameters for what if analysis? i.e. parameters that we can adjust on the fly without refreshing the entire data model, which in turn is used in calculating measures?
As an example, while analyzing sales data, if we have a parameter for Discount, we can specify a discount value in this parameter and see the impact on other calculated measures using this parameter.
It would also be great if we had the ability of making such parameters visible on the report page (text box, drop downs, etc.) so that users can change the parameter values in report view in PBI service.
Rajnish Sinha
shared this idea
8 comments
-
Mark Walter
commented
I think this is already possible in a Dax measure that references a disconnected table that holds your parameters. Write your IF statement to look to the 'max' number option selected in your parameter table. If max=1, then ..., if max=2, then ... that way, when you slice to 1, you get a different variable calculated in your result. Choose 2 and your measure changes again.
-
Ivan Tamburic
commented
It would be also great if we had ability to bind user file (excel, txt, csv) to parameter, directly on reports.
e.g.
Filter report using file that contains customer IDs. -
Alan Walnoha
commented
We also would like to have a slider for these What If analysis.
-
Anonymous
commented
We have the same need. We need a mechanism that avoids users going to the data model and tweaking parameter tables.
-
Rajnish Sinha
commented
Thanks Jan, but in this case you're pre-defining the value set, it would be great to have ability to either pre-define, or just specify a value on the fly in a text box in the report.
-
Jan
commented
You can already do this with disconnected tables. See the following two posts:
http://www.daxpatterns.com/parameter-table/
https://www.powerpivotpro.com/2010/06/use-slicer-values-in-a-calculation-with-powerpivot-dax/
-
Tony Kriston
commented
Great idea.
-
Cherryl
commented
Great idea... the more interactive, the better!