Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to create a scatter plot graph with the past 24 mths trend.
The dots are the sales of each respective sales person, and I would like to show a median line of all the sales person.
How do I get the past 24 months trend and to put the respective sales person as an individual dot?
Hi @naoki
The dots are the sales of each respective sales person, and I would like to show a median line of all the sales person.
You could add a median line. (Analytics->Median line)
How do I get the past 24 months trend and to put the respective sales person as an individual dot?
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
Apologies, I realised I was unclear with my question.
For the scatter plot, I would need couple of things
1. 24 Months trend (To show their sales for the past 24 months), from month 1 to 24.
- 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.
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.
Thank you.
Hi @naoki
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 Independent variable and Dependent variable of the corelation?
Best Regards
Maggie
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.
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. 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |