This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
HI everyone,
I have some data which is essentially, team_name, agent_name and task_volume.
Each agent belongs to a team and a team can have multiple agents. Task_volume is the volume of tasks completed by an agent.
I want to create a visualisation that shows data points for the volume of tasks completed by each agent, however I need this grouping by the team name. So the x-axis would be team name, the y-axis is the task volume, and each data point on the visualisation would be each agents volume of tasks completed.
I've done something similar in Qlik however I need to mirgrate this over to powerbi but I am struggling to replicate this using a scatter plot. Is this possible?
A (very) rough mockup I drew is below - each point is the respective agents task volume:
Solved! Go to Solution.
Hi @floppysock ,
Based on your description, I have created a simple sample:
Please try:
Final Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ah that's a really simple solution - thanks for helping.
Hi @floppysock ,
Based on your description, I have created a simple sample:
Please try:
Final Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 25 | |
| 20 | |
| 20 | |
| 20 | |
| 20 |