Forum Discussion
Filtering only particular columns based on a filter selection
I have two data sources: One with a list of employees, and one with a list of classes and those who participated.
Ive created a measure and visual to show which % of each region has completed the course selected from a table visual / filter, but on the bottom of my page, I want to have a list of all the employees (which ive grouped by manager already in a matrix), and their "status" of whether or not they attended the course.
However, when I filter on a particular course, it filters the whole table, so all I get is a list of employees who have attended the course, filtering out those who have not.
How do I keep both those who have and those who haven't attended the course in the list, but show the status of whether or not they attended, without filtering the table from the course selected?
2 Replies
Source Data Table 1:
Manager Employee Bill Tom Bill Bob Bill Mark Source data table 2:
Course Employee Status A Tom Completed A Bob Completed A Brian Completed B Tom Completed What I want to create:
Slicer: Course A
Manager Employee Status Bill Tom Completed Bill Bob Completed Bill Mark (blank or Incomplete) The problem:
Because Mark did not complete the course, he is not in table 2. Therefore, when I filter my final output by a specific course, he disappears instead of lets me have an incomplete status