Forum Discussion
Slicers impacting only specific data
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 |
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
3 Replies
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
Thank you! I will try to give this a shot this week!
