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,

 

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

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'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

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

      • richbenmintz's avatar
        richbenmintz
        Resident Rockstar
        6 years ago

        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!

    • 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!