cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NilPil Frequent Visitor
Frequent Visitor

Need Help

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Need Help

Hi @NilPil ,

 

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

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NilPil Frequent Visitor
Frequent Visitor

Re: Need Help

Hi

 

Its okay to see this as table.

I am able to show case

1.  How many vacancies for each Department.SampleScreenshot.gif

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.