Dynamic change in line values

[Switto]

Hello Everyone,

I am working on a Quality dashboard that shows the quality of the employees.

The client is asking to accommodate the expected quality % according to their joining date, as there are different levels of employees(Associate, Sr. Associate, etc) so it differs.

Title	Training	Beginner	Proficient	Expert
X -> X+30	X+1 -> X + 120	X+120 -> X+180	> X+180+
Jn. Analyst	70%	92%	93%	96.50%
Analyst	70%	92%	93%	97%
Sr. Analyst	70%	92%	93%	97.50%
Lead Analyst	70%	92%	93%	98.50%

For example, Person A joined as Jn. Analyst in Oct. and we are calculating his quality on Feb. then the expected quality should like :

July: 70% 

Aug : Oct : 92%

Nov : Jan : 93% 

Feb onwards: 96.50 %

As for now, my monthly graph is showing the current month expected quality % instead of the above-mentioned % in all the months.

Would appreciate your help.

[v-eachen-msft]

Hi @Switto ,

What's your expected result?

You could refer to the following link to get answers quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Switto]

@v-eachen-msft: Thanks for the reply.

I have tried putting the pic of the current graph however, it was showing error to upload.I have tried in paint now.

So, I am looking for a solution where once they select the person from the slicer, Month graph should update with expected quality value and actual quality value. 

As you see below, Line graps is the expected quality from the "Person A", and stacked is the actual quality % he has delivered.

I have already done the actual % part however, not been able to get the expected quality % part as it is dynamic in nature and depends on the date of Joining(explained in the intial post).

Hope it works now.

Sorry for the confusion.

Thanks