Slicers impacting only specific data

[mgwarren219]

Hello I am working on a report that will show all Action Ttems for a specific department based on the Department you select from the Slicer. This report is built off a SP list but not using the out of the box BI that now comes with List. The Department field is a single select field and when a user heads to this page they can select the department and see all things Due and Overdue for the Selected department. 

What I am looking to have is a table that shows items that OTHER departments own but impacts the department selected. This way we can see everything related to one department in one glance. 

Is this possible? 

Here is a brief example (I hope this helps)

When I select the Marketing Team I can see everything blue (task 2 and 3) across the page. BUT in a separate table, I would also like to see the item in orange (Task 87) and it's details

Department	Item	Due Date	Impacts others?
Marketing	Task2	Jan 1st, 2024	IT
Marketing	Task3	May 1st, 2024	n/a
IT	Task87	June 7th, 2024	Marketing
Finance	Task 32	May 3rd, 2024	n/a

[mgwarren219]

Thank you! I will try to give this a shot this week!

[amustafa · Accepted solution]

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

[mgwarren219]

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