How to preserve Size in a Scatter Plot when adding a Ratio Line

[HugoArtus]

Hi,

I have a scatter plot based on some data, as shown below. Importantly, I am using a column from my Table in the Size field. It behaves as intended.

However, when I try to add a Ratio Line, the Size field stops working, it essentially makes the bubbles as big as each other.

How can I get a Ratio line (or something similar) on my scatter plot whilst showing accurate bubble Sizes?

[v-jayw-msft]

Hi @HugoArtus ,

I don't see 'Ratio line' too, my Power BI Desktop version is Nov2020.

Maybe you could try to update the application to latest version and check if the problem still exists.

Best Regards,

Jay

[Pragati11]

Hi @HugoArtus ,

What Ratio line are you talking about here?

For scatter chart I see following options:

 Also when I add one of the above lines, I see the Size of the the bubbles stay right at my end.

[HugoArtus]

@Pragati11 

Thanks for responding.

Weird, I see the following options: 

It is only when adding the Ratio line that the bubble sizes get weird but this is the line I need in the chart (unless there is another way to produce a Line of Best Fit or something similar).

Any advice?

[Pragati11]

Hi @HugoArtus ,

What visual are you using? I am using a Scatter Chart visual as shown below:

Also I am working with Power BI November 2020 Update.

Thanks,

Pragati

[HugoArtus]

@Pragati11 

I am also using a Scatter plot

It looks like I am using the Aug-20 version (2.84.861.0), could this be the issue? Not sure if I can get an update to the Nov version because this is controlled centrally my by employer.