Bar chart - used like tally marks

[Anonymous]

I have a list of users, and through out the year they are tested.  Pass or Fail are the results each month.

I have used slicers to determine for 12 months, the total number of times each user has passed.  My data now looks like this

userid	pass total	activestatus
user1	11	active
user2	11	active
user3	11	active
user4	11	inactive
user5	10	active
user6	10	active
user7	10	active
user8	10	active
user9	10	inactive
user10	10	active
user11	10	active
user12	10	active
user13	9	active
user14	9	active
user15	9	active
user16	9	active
user17	9	inactive
user18	8	active
user19	8	active
user20	7	active
user21	7	active
user22	7	active
user23	7	active
user24	7	active
user25	6	active
user26	6	active
user27	6	active
user28	6	active
user29	6	active
user30	6	inactive
user31	6	inactive
user32	6	inactive
user33	5	active
user34	3	active

My goal is to great a column bar chart to show by active status, axis categories would be 12 down to 1 for number of months in a year, and the bar for each would show 3 active for 11 times passed, 7 active for 10 times passed, 4 active for 9 times passed,,,,, and so on....

My total passed is a calculation, and currently i have a slicer for the year and testing day/month, and select those that i want to filter by.

My goal is to answer: how many users passed all 12 tests, who passed 11 tests, but compare them side by side.

[amitchandak]

@Anonymous , I do not see any dates here. Can share expected output in table format.