Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating a Dynamic Curve from Input Parameters

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?...
Need Help
  • richbenmintz's avatar
    richbenmintz
    6 years ago

    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!

richbenmintz's avatar
richbenmintz
Resident Rockstar
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    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!