Forum Discussion

kelleycorreia's avatar
kelleycorreia
New Member
9 years ago

Using PowerBI for resource management

Hi there,   I'm trying to use PowerBi to create a dashboard for my department that will show assignments sorted in a couple different views:   1. by creative resources 2. by project name/initiat...
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

kelleycorreia

 

1 First you need the data source (SQL, Excel, CSV, or Another)

 

2 Look if you need to do some transformation to the data.

 

3 Create the visuals ad if necessary the measures.

 

 

Post questions or sample data and the expected result and the community will help you

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello, 

 

In managing resources, I have an exccel file with all of the teams and projects everyone is one. 

One of the views I am working to build is, if I select an initiative, i want to know whose on the team, but I also want to show where those other team members are allocated to. 

 

For example: Myra is in X but also in the following teams. 

Team A.

Team B. 

 

With this information the teams can reallocate resources as needed quickly. 

 

I tried building a filter, but it only gives me for that one initative. is there a DAX, that can capture on a different view, the other infomation I need. 

 

Thank you