Bar Graph - Show count and percentage per person vs group

[Ananthak275]

hello everyone,

I'm trying to create a bar graph that contains two types of data - per person and group beside each other. The individual section would have a slicer so that a comparison of each individual vs the group can be completed, as long as the slicer doesnt impact the group bar. the screen shot is something im trying to create. my data is currently like this;

Assigned	Created	Closed	How many days it took
Person 1	May 13, 2020	May 20, 2020	7
Person 2	May 13, 2020	May 18, 2020	5
Person 3	April 14, 2020	April 20, 2020	6
Person 4	April 1, 2020	April 10, 2020	9
Person 1	June 3rd, 2020	June 25, 2020	22
Person 1	June 15, 2020	June 16, 2020	1
Person 2	May 1, 2020	May 3rd, 2020	2
Person 3	June 28, 2020	June 29, 2020	1

 

[JustynaMK]

Hi,

As you want to slice by the individual, then the first part of the bar graph is easy - simply drag the value field into the bar chart. I suspect that the value field will be "How many days it took" column. With that, every time you select a different individual, the value will automatically update.

The second part is where you need to create a DAX measure so that it always ignores your Person selection. For example, if your Group shows the average of days, you can calculate something similar to:

mGroup =
    CALCULATE(
        AVG(table[How many days it took]),
        ALL(table[Assigned])
    )