Forum Discussion
Visualization to show cross projects
Hello PowerBI masters,
I would like to ask you how to solve problem which I found in my task.
I need to create a chart that shows the project and the teams that are working on a specific project.
But I have to show only projects where is more than one team.
I have 3 main tables which I'm using to achieve some results.
Employees
Projects
EmployeeBooked where I have estimated hours for specific project.
This is simple model which reflect my real one.
Employee table
Projects table - where each project has main team but multiple team can working in this project.
EmployeeBooking table.
I'm trying to achive stacked chart which be focusing only on Projects with multiple teams.
But the problem is than I don't know how to filter out Project with single team.
My measure to count Teams:
If enyone can give some tips how to calculate and show in proper way projects only with multiple teams I'll be very grateful 🙂
Have a nice day!
1 Reply
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
