Forum Discussion

floppysock's avatar
floppysock
Frequent Visitor
3 years ago
Solved

Scatter Chart help

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: 

 

  • 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.

2 Replies

  • 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.

  • floppysock's avatar
    floppysock
    Frequent Visitor

    Ah that's a really simple solution - thanks for helping.