Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Custom Visuals Ideas will be in read-only beginning Friday, Feb. 28 as we prepare to move these ideas to the new Fabric Ideas.

BPONIFG1078

Resource Allocation Table on Power BI

Submitted by on ‎11-03-2023 03:29 AM

Hi guys!

 

I need help with creating a table on Power BI which show the allocation of resources on each project. The problem is: each stakeholder could be on multiple projects, therefore I count the total no. of projects each person has on his/her plate.

BPONIFG1078_2-1699006598059.png

But when I select a particular stakeholder 'Name K', the table below will show all the projects in the portfolio to me withouting only filtering what projects 'Name K' have on his plate. For example, for Name K, I would like to see in the table Project A, B, D, E and F with a yes only whereas Project C will disappear as Name K is not allocated on that project.

 

BPONIFG1078_5-1699006871051.png

Is there a way the table can only show the specific projects for each person? Or are there any other visual presentation you would suggest to me?

 

Really appreciate your help and advice! 🙏

 

 

 

 

 

Status: New
See more ideas labeled with: