Forum Discussion

lurked's avatar
lurked
Regular Visitor
6 years ago

Clustered bar or column chart doesn't summarize correctly?

So I'm trying to make a clustered bar or column chart of tasks by status, assigned to different persons, but PowerBI doesn't correctly summarizes the data.

 

What I mean is, I have 3 statuses :

  1. Not Started
  2. In Progress
  3. Completed

And 3 employees :

  1. boivin.francois
  2. duchesne.tommy
  3. proulx.david

And I want to have a clustered bar or column chart which lists the amount of tasks of each status for each employee. The issue is that as soon as one of the employees has a single task of one of the status, the entire amount of tasks of that status will be shown as being assigned to that employee.

 

Example :

You can see in the table above that I have :

  • 5 "Not Started" tasks
    • 3 boivin.francois
    • 1 proulx.david
    • 1 duchesne.tommy.
  • 3 "In Progress" tasks
    • 1 boivin.francois
    • 2 proulx.david

But when we look at the chart, it shows 3 tasks "In Progress" for boivin.francois and also 3 for proulx.david, and 0 for duchesne.tommy. If I add a single "In Progress" task for duchesne.tommy, the total of 4 will be shown for all 3 of the employees, as we can see for the "Not Started" tasks, which shows 5 for every employees.

 

I'm not sure if it's a bug or if I simply haven't configured my chart correctly, but I don't understand what's going on right now, anyone has an idea?

 

I tried several ways of setting the different fields in the chart, but to no success, here's how my parameters look right now :

2 Replies

  • 1. If the count of Assign ID coming from a different table just check the join with those tables

    2. Also, In case, joins are correct try count distinct

    • lurked's avatar
      lurked
      Regular Visitor

      AssignID is from the same table as the tasks, the only field that's from another table is the "Login", but it's already joined :

       

      If I do Count Distinct, all the sums become 1.