Latest Enterprise DNA Initiatives

Scatter plot custom lines

Hi Team,
I have a client that wants to put these y = x (and y = x +/-10% or 20% etc.) lines onto a scatter plot. As far as I am aware this is not currently possible in Power BI. If this is not possible, would it be possible to create a measure that falls within the bounds of a given deviation? eg y = x +/-10%

@jmaikido ,

I don’t ever say something is impossible within Power BI anymore, because someone more clever almost always comes along and proves me wrong. However, I don’t see a way to do this within native Power BI.

On the other hand, if the client is willing to use R in conjunction with Power BI, this is a simple task. Per the article below you can add any line to a scatter plot within R. Alternatively (or in addition) you can also easily calculate the regression line and the residuals, and then in Power BI conditionally format each point based on whether it is greater than or less than your threshold residual amount.

https://stats.idre.ucla.edu/r/faq/how-can-i-do-a-scatterplot-with-regression-line-or-any-other-lines/

For a look at how you can calculate, plot and build measures based on R-generated residuals, check out the entry we put together for the COVID dashboard Data Challenge a few months ago:

I hope this is helpful.

– Brian

2 Likes

Brian, Thanks for a most informative and detailed reply. I have referred this on to my client. Nonetheless, your reference to using R may assist them further.
Rgds, John

1 Like

Hi @jmaikido did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @jmaikido, we’ve noticed that no response has been received from you since the 30th of May. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @jmaikido, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!