Forum Discussion

carlosxxss's avatar
carlosxxss
Regular Visitor
3 years ago

Showing table with python containing trendline formula from scatter plot

I have a Python script running in Power BI desktop that shows a scatter plot with a exponential and linear trendline. Also it shows the formula of the trendlines and the R-squared value. My dataset c...
Need Help
Show and Tell
  • carlosxxss's avatar
    carlosxxss
    Regular Visitor
    3 years ago

    Hi Ibendlin. Thanks this points me in the right direction but not exactly what i wanted. I created the table below. But i want to move the exponential en linear trendline to the columns and on the rows i want the different segments.

     

    What i have now:

    What i want:

    SegmentExponential formulaLinear formulaExponential R-squaredLinear R-squared
    Segment 1    
    Segment 2    

     

    I have a sample dataset in this onedrive link: https://1drv.ms/u/s!AotJBlCCCXxigpNv7xxhBpxVSxeUYQ?e=xY5PJh 

     

    I can't figure out this next step