Forum Discussion
Or Slicing between multiple tables
Create unifed dimension table
Steps:
1. Create a combined Owner table as in Power Query (or DAX if preferred. below steps are PQ).
... append project owner column from the project table and task owner column from the task table.... remove duplicates
2. name this table say "Person or Person dim" of your choice. and say column as "Name" Use it as your slicer source.
3. Create relationsips
... Connect Person Dim[Name] to Project[Project Owner] (one-to-many).
... Connect PersonDim[Name] to Task[Task Owner] (one-to-many).
4. Build visuals (remember for slicer use this new table)
Create unifed dimension table
Steps:
1. Create a combined Owner table as in Power Query (or DAX if preferred. below steps are PQ).
... append project owner column from the project table and task owner column from the task table.
... remove duplicates
2. name this table say "Person or Person dim" of your choice. and say column as "Name" Use it as your slicer source.
3. Create relationsips
... Connect Person Dim[Name] to Project[Project Owner] (one-to-many).
... Connect PersonDim[Name] to Task[Task Owner] (one-to-many).
4. Build visuals (remember for slicer use this new table)
This is close, but it is really just showing me when a project is owned by someone, or at least the result is the same as if I just take the project owner column.
What I want to see is
- John owns Project X as the project manager
- John works on Project Y
- Sam owns Project Y
- John reports to Sue
- Sam reports to David
When Sue runs the report I want her to see Project X with John's name as the project manager and Project Y with Sam's name as the project manager. Right now I only get Project X.
The problem I'm facing is its a many to many relationship. A person can own many projects, a person can work on many projects, therefore I'm looking for many people working on many projects associated to a manager. I swear I've done this in Tableau and it wasn't this difficult but its been years.
Hi keatonbeyer ,
Thanks for reaching out to the Microsoft fabric community forum.
Is there a field in your PersonDim that defines each person’s manager?
Best Regards,
Community Support TeamHi keatonbeyer ,
Can you please confirm whether the issue is sorted or not.Hi keatonbeyer ,
Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster.
Best Regards,
Community Support Team