Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
Proud to be a Super User!
Thank you! I will try to give this a shot this week!
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
Proud to be a Super User!
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 |
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |