Compare individuals to the team

[Anonymous]

Hello all,

Here's my goal: I want to show the average time spent in review, testing, and draft for the team as a whole as well as these individual employees. Can I display all of this in one stacked column chart?

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

You could try the following steps:

1. Add a table for slicer via Enter data:

2.Create measures for teams and individuals :

team average = 
SWITCH(MAX('ForSlicer'[Type]),"Review",CALCULATE(AVERAGE('Table'[Days in review]),ALLEXCEPT('Table','Table'[Manager])),"Test",CALCULATE(AVERAGE('Table'[Days in testing]),ALLEXCEPT('Table','Table'[Manager])),"Draft",CALCULATE(AVERAGE('Table'[Days in draft]),ALLEXCEPT('Table','Table'[Manager])))

individual average = SWITCH(MAX('ForSlicer'[Type]),"Review",CALCULATE(AVERAGE('Table'[Days in review]),ALLEXCEPT('Table','Table'[Employees])),"Test",CALCULATE(AVERAGE('Table'[Days in testing]),ALLEXCEPT('Table','Table'[Employees])),"Draft",CALCULATE(AVERAGE('Table'[Days in draft]),ALLEXCEPT('Table','Table'[Employees])))

Then you could create visuals as shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-eqin-msft 

Beautifully done. I appreciate the help.

[Anonymous]

@Anonymous 

Yes, you can do that but the technique you have to use is not something that PBI does out of the box. You'll have to put a bit of effort into it. Alberto Ferrari discusses such a technique in his videos on YouTube. You can also find something similar in the materials by The Guy in A Cube (Patrick and Adam) Guy in a Cube - YouTube.

I would give you the exact link but I can't remember it. However, I'm 100% sure they show how to achieve such arrangements.

[Anonymous]

@Anonymous 

Thank you for pointing me in the direction, but without a specfic location I have still yet to find a solution.