I am trying to make a slicer chart for three teams: Team A, Team B, and Team C. The categories are annual absences, monthly absences, weekly absenced, and daily absences. I want to create a slicer so that when someone clicks the slicer category of Team A, five graphs are shown to illustrated Team A data: annual absences, monthly absences, weekly absenced, and daily absences. So far, I can create five separate slicers but I have to click on Team A on all five slicers spearately to display charts. I want to be able to have one slicer and click Team A once to display all five graphs, then click Team B and display all five Team B graphs, etc. This is my dashboard.
How can I do this?
How can I do this?