24 Months Scatter Plot Graph

Question

Hi,&nbsp;&nbsp;I would like to create a scatter plot graph with the past 24 mths trend.&nbsp;&nbsp;&nbsp;The dots are the sales of each respective sales person, and I would like to show a median line of all the sales person.&nbsp;&nbsp;How do I get the past 24 months trend and to put the respective sales person as an individual dot?&nbsp;&nbsp;

v-juanli-msft · Answer

Hi&nbsp;naoki&nbsp;
The dots are the sales of each respective sales person, and I would like to show a median line of all the sales person.&nbsp;
You could add a median line. (Analytics-&gt;Median line)
&nbsp;
How do I get the past 24 months trend and to put the respective sales person as an individual dot?&nbsp;
You could add datetime field in “Play axis", add "person name" in the "legend" field.
Reference:
https://radacad.com/storytelling-with-power-bi-scatter-chart
&nbsp;
Best RegardsMaggie
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

naoki · Answer

v-juanli-msft&nbsp;&nbsp;Apologies, I realised I was unclear with my question.&nbsp;&nbsp;For the scatter plot, I would need couple of things&nbsp;&nbsp;1. 24 Months trend (To show their sales for the past 24 months), from month 1 to 24.&nbsp;- This will show the total sales per month up till 24 months for all sales person. (E.g) Salesperson A, Month 1 10k, Month 2, 20k and so on), however I would need to show for all, as I am intending to create a corelation at a later stage using this result.&nbsp;2. I also would like to plot my own average line which should be showing an upwards trend as that is the benchmark that I would want to see the sales person growth vs my predetermine sales person.&nbsp;&nbsp;Thank you.

v-juanli-msft · Answer

Hi&nbsp;naoki&nbsp;
You could add "date" in the "Play Axis" as this article suggested.

Or add "date" in "Axis", add "sales person" in "Legend" field.

There are 12 months a year, which 24 months do you mean? the last 24 months from the current months?
What is the&nbsp;Independent variable and&nbsp;Dependent variable of the&nbsp;corelation?
&nbsp;
Best RegardsMaggie

naoki · Answer

The 24 months that I meant from the day that the sales person joined. It doesn't matter to me when do they join, what matters is when did they made the sales. So if a sales person had their first sales in his 3rd month, a dot will appear on the 3rd month.&nbsp;&nbsp;Something like my graph here, I sort of managed to get the data to show for 24 months, however, I have yet to check for issues.&nbsp; As for the white line, it should be an average line that is preset by me, whereby i will be able to identify which sales person is performing below average and it needs to be as per what I drawn a growing line.&nbsp;&nbsp;&nbsp;

Forum Discussion

24 Months Scatter Plot Graph

4 Replies

Related content

Scatter graph

Scatter Graph HELP!!!!

Scatter Plot With Month and Product ID

Scatter Chart

Month/Year under chart/graph