Need Help

[Anonymous]

I am new to power bi and trying to solve a problem. 

This is a similar problem that I am trying to solve but cant exposed the data, so created a dummy set of data to replicate the problem.

Problem: The budget is to hire 15 teachers that will work across 5 Department. The goal is to prioritize the hiring process so that we can make each department whole as quickly as possible. Also to find out as the vacancies in one department is addressed how the other department vacancies get addressed.

What we need to show,

1. There are 9 total vacancies that are impacting 5 departments.

2. Science/Chemistry2 is impacting 4 departments and as this is filled how much % of the need for each department is met. 

Sample data:

Dept,Subject,Specialty,Need to Hire

Dept1,History,History2,Y

Dept1,Science,Physics2,N

Dept1,Science,Chemistry2,N

Dept1,History,History1,Y

Dept1,Language,French1,Y

Dept1,Language,Spanish1,N

Dept1,Language,French2,N

Dept1,Language,Spanish2,N

Dept1,Science,Physics1,N

Dept1,Science,Biology1,Y

Dept1,Science,Chemistry1,Y

Dept2,History,History2,Y

Dept2,Science,Physics2,N

Dept2,Science,Chemistry2,N

Dept2,History,History1,Y

Dept2,Language,French1,Y

Dept2,Language,Spanish1,N

Dept2,Language,French2,N

Dept2,Language,Spanish2,N

Dept2,Math,Algebra2,N

Dept2,Math,Algebra3,N

Dept2,Science,Physics1,N

Dept2,Science,Biology1,Y

Dept2,Science,Chemistry1,Y

Dept3,History,History2,Y

Dept3,Science,Physics2,N

Dept3,Science,Chemistry2,N

Dept3,History,History1,Y

Dept3,Math,Algebra2,N

Dept3,Math,Algebra3,N

Dept3,Math,Algebra1,Y

Dept3,Math,Geometry1,N

Dept4,History,History2,Y

Dept4,Language,French1,Y

Dept4,Language,Spanish1,N

Dept4,Language,French2,N

Dept4,Language,Spanish2,N

Dept5,History,History2,Y

Dept5,Science,Physics2,N

Dept5,Science,Chemistry2,N

Dept5,History,History1,Y

Dept5,Language,French1,Y

Dept5,Language,Spanish1,N

Dept5,Language,French2,N

Dept5,Language,Spanish2,N

Dept5,Math,Algebra2,N

Dept5,Math,Algebra3,N

Dept5,Science,Physics1,N

Dept5,Science,Biology1,Y

Dept5,Science,Chemistry1,Y

Dept5,Math,Algebra1,Y

Dept5,Math,Geometry1,N

[v-yulgu-msft]

Hi @Anonymous ,

What result do you want to achieve based on above dummy data? How do you want to visualize the output?

Regards,

Yuliana Gu

[Anonymous]

Hi

Its okay to see this as table.

I am able to show case

1.  How many vacancies for each Department.

2. I am able to find out if I select one department, how many vacancies are still open.

I am not able to show:

1.  If I select a deparment and potenitally fulfil that department.. how this is going to impact other department.

e.g. Need a chart that would say If I fulfill Dep 1 which has 6 vacancies will also help
> Dept#2 with 6 out 8 vacancies.
> Dept#3 with 2 out 5 vacancies
etc.