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 co...
Hi Anonymous ,
Can you pls share some sample data and the expected output.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
In case it did not help, please provide additional information and mark me with @ so that I can investigate further
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