Sample workbook attached.
I have run into this problem a couple of times now, and so I thought I'd ask if you have a work around or a different approach to address this scenario.
Basically, I often write calculations that return a count of student [ID] based on specified criteria. I am using a distinct count of student [ID] to produce numbers (in this workbook, its the "Annual Review This Month", "Annual Review Next Month", etc. calculations.
Once I've created measures based on those counts, I can display them easily enough in a bar chart. However, I have been unable to find a good way to filter from the bar chart to a student list (which is commonly required in my work).
Can anyone take a look at the simple dashboard I've mocked up, and see if you can help me link the two together? I want to return the students who match up with the bar chart above--so, students who are up for review this month, next month, etc. should be displayed in the list below when a bar is clicked.
I assumed since the student's ID is used in both sheets, it would automatically link them but I guess because I am aggregating the count of IDs on one sheet and simply displaying the dimension in another, it won't work as I expect it to. In the bar chart as-is, each individual ID can be filtered down to and the bar is broken up into individual pieces, but I cannot filter for the entire bar (hopefully that makes sense). I am more concerned about the entire bar and not the individual chunks that make it up.
Any advice anyone can give on this type of scenario would be great. I often write calculations to get distinct counts based on returned student IDs, so I certainly need a different approach if I can't link these to a student list.
I really appreciate any help anyone can provide here.