Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JAnders
New Member

Display the R-Squared Value of a Trend Line

Hello, I am new to Power BI. I'm working on a scatter plot that has a trend line in it. How do I see the R-Squared value for the trend line? Thank you in advance!

4 REPLIES 4
jahiskey
Employee
Employee

Can someone explain why this is not a built in feature? This seems like it would be a very common need for many people.

akchandarana
New Member

Agree that this should be a simple built-in check-box option when adding a Trend Line to a Scatter Chart. This is the best solution I could find for a single trend line: https://www.c-sharpcorner.com/article/how-to-get-correlation-coefficient-in-power-bi/

or if you need something more dynamic (in DAX): https://techcommunity.microsoft.com/t5/healthcare-and-life-sciences/use-custom-dax-to-create-a-linea...

Nothing built-in at this time. You would have to manually calculate it as a measure.

This is basic Excel Chart formating 101.  Are there plans to add this functionality in BI?  There is already resistance to this product and if the most elemental of statistical values require manual calculations, that's not going to help.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.