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

View all the Fabric Data Days sessions on demand. View schedule

Reply
PowerB
New Member

Get rid of Dots from regression line that is based on measured column

Hi,

I have a line chart for Linear regression that is based on a measured column (named "Measured") and a data column ("Job rate"). I want to get rid of blue circles on the regression line (highlighted in below picture), but want to keep the other data points that are not on Regression line. How can i do that? 

PowerB_0-1652286640932.png

Below are the configuration of my chart

PowerB_1-1652286859156.png

 

PowerB_0-1652287450978.png

 

below is the data table 

Gender PredominancePoints ValueJob RateColumn
Female128$25False
Female384$32False
Female426$32False
Male215$27True
Male563$35True
Male592$37True
Male645$37True
Male665$40True

 

and below is the measured column

Measure =
var Regression = SUMX(FILTER('Proportional Method Analysis',[Column] = True), 0.0256 * 'Proportional Method Analysis'[Points Value] + 21.7464)
return Regression
 
ideally, i want it to look like this:
PowerB_4-1652287338143.png

 

will appreciate your help 🙂 
 
Thanks,
5 REPLIES 5
mahenkj2
Solution Sage
Solution Sage

Hi @PowerB ,

 

I am interested to resolve this. Good thing is, that you have clarified most of the things, but I am unable to replicate the visual you shows. Is this a scatter plot? I can't put two variables on Y-axis as you did:

 

mahenkj2_0-1652680447030.png

 

 

 

Hi, I used Line chart.

lbendlin
Super User
Super User

Please define what you mean by "on the regression line". What's the over/under on this definition?  Exactly on the line? A little bit off?  How much exactly?

Hi,
In the first picture, i have higlighted in red circles the points "on the regression line". hope this clarifies.

thanks 

if the data value and the regression value matches for the same place on the X axis then return BLANK() instead of the data value.

 

But - none of your values match. Close, but no match.

 

lbendlin_0-1652724395488.png

 

lbendlin_1-1652724589471.png

 

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors