Forum Discussion

Maybrick1046's avatar
Maybrick1046
Frequent Visitor
3 years ago

Scatter Plots vs. Excel Scatter plot. 1 Independant Variable, 1 Dependant Variable Date for X Axis.

I am a real estate appraiser.  I use Excel and Power Query extensively.   I am trying to understand Power BI, and what a simple task in Excel seems daunting in PowerBI. I measure market change via li...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Maybrick1046 , 

Here are some ducuments, please refer to.

Use Custom DAX to create a Linear Regression Trendline with a Dynamic Date Hierarchy in Power BI - Microsoft Community Hub

A Complete Guide to Bubble Charts | Tutorial by Chartio

Present your data in a bubble chart - Microsoft Support

Linear Regression In Power BI (c-sharpcorner.com)

 

If it still does not help, please provide more details.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Maybrick1046's avatar
Maybrick1046
Frequent Visitor
3 years ago

The links provided are okay, and I appreciate them.  I understand how to make this work now.  To me, it's disappointing that something so simple in Excel and so complex in Power BI.  Creating a scatter plot and adding a regression line for a simple one dependent and one independent variable should be "built-in" like it is in Excel.  

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Maybrick1046 ,

    I am sorry. 

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.