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
Solution SageYou 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
