Scatter plot custom lines

[jmaikido]

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%

[BrianJ]

@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:

Power BI Challenge 11 - Covid 19 Reporting from Greg, Brian, Jarrett, and Mudassir

All, Introduction For a while, we’ve been planning to do a joint entry to explore the dynamics of collaborative Power BI development, in order to provide the Enterprise DNA community with a set of practical, tested recommended practices. Our ultimate plan is to use Analyst Hub as the primary mechanism to facilitate this collaboration, but the first time through we thought we would focus on the broader elements of learning to work together as a team, since each of us has only ever been the sole…

I hope this is helpful.

– Brian

[jmaikido]

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

[EnterpriseDNA]

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!

[EnterpriseDNA]

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.

[EnterpriseDNA]

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!