Forum Discussion
Slicers impacting only specific data
You can duplicate your base table and run the join from base table on Department to Impact Others? column in duplicate table. (see the attached .pbix file.
Report view with slicer
You can duplicate your base table and run the join from base table on Department to Impact Others? column in duplicate table. (see the attached .pbix file.
Report view with slicer
I think I got a step closer but it is still not working. I realized I may have left out the fact that the Impacts Other field may contain blanks BUT may also contain MULTIPLE departments.
Here is an example of what it could look like. This is also all coming in from a MS List, so my assumption is I have to Duplicate my main table, so I can expand my 'Impacts Others?' field so all the other departments are on their own line, created duplicates. Then do as you recommended above?
| ID | Department | Item | Due Date | Impacts others? |
| 1 | Marketing | Task2 | Jan 1st, 2024 | IT, Finance |
| 2 | Marketing | Task3 | May 1st, 2024 | n/a |
| 3 | IT | Task87 | June 7th, 2024 | Marketing |
| 4 | Finance | Task 32 | May 3rd, 2024 | n/a |