Creating a Dynamic Curve from Input Parameters

[Anonymous]

I am trying to build a dashboard tool that allows some of our engineers to adjust a set of parameters that are used in defining the equation of a curve. 

What is the best approach for doing this? Does the Python or R visual allow you to read in table inputs like a series? 

In the example I am trying to build, would follow the following equation for a hyperbolic curve.

hyperbolic_curve(t, qi, b, di)

t = time

qi = initial rate

b = hyperbolic constant

di = nominal decline rate

Output = qi/((1.0+b*di*t)**(1.0/b))

Thanks

[vanessafvg]

what are you expecting, can you demonstrate what you want to end up with.

maybe you can provide some dummy data?

[Anonymous]

I was thinking the report page would have several parameter buttons and sliders that give the engineers the ability to set different inputs and those changes automatically changing the visualization of the curve. 

[richbenmintz]

Hi @Anonymous,

Are you able to provide some sample data, what if parameters should work just want to make sure that the results match the equation, 

what variables are mapped to parameters and what variables are mapped to values in your data.

Thanks,

Richard

[Anonymous]

@richbenmintz I've not built anything yet. I am unsure how to tackle this as I need to visual to actually plot the equation of the curve. 

Can the python visual do that? Can you feed the python visual a what-if parameter?

[richbenmintz]

Hi @Anonymous,

you can use what if parameters in your Python Visual,

Hope this Helps,

Richard 

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

[Anonymous]

@richbenmintz 

I added some additional parameters to this model to see if this is feasible. It is in line with what I am trying to build but I am unsure how to get it to graph 

https://github.com/rstover/PowerBI 

[richbenmintz · Accepted solution]

Hi @Anonymous,

I have created a measure called hyperbolic_equation in the model, pbix here, sample.pbix 

hyperbolic_equation = divide([Initial Production Rate (qi) Value],(POWER((1.0+[Hyperbolic constant (b) Value]*[Nominal decline rate (di) Value]*([time (t) Value])),(1.0/[Hyperbolic constant (b) Value]))))

Then i add the measure to the values area and added the following python.

import matplotlib.pyplot as plt
dataset.plot(kind='line', x='time (t) Value', y='hyperbolic_equation', color='red')
plt.show()

Hope this Helps,
Richard

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

[Anonymous]

Thanks. Do you mind showing a higher resolution picture? I can't see the details

[richbenmintz]

Hi @Anonymous,

Link to a pbix file, you may have to change the pathing for python, but the file will show you have when you change the param the visual changes

sample.pbix,

Richard,

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

[Pragati11]

Hi @Anonymous ,

Try checking what-if parameters in Power BI:

https://radacad.com/power-bi-what-if-parameters

Thanks,

Pragati