Automatic recalculation on average weighted curve

[CRUANO]

 From a drop-down list of several projects, I would like to be able to choose the items in any order and that the average weighted curve is automatically recalculated, depending on the weights of each selected project, since today only the sum of each project is what is shown in the curve so at the end of the curve the sum is greater than 100% I thank you for your help.

[v-qiuyu-msft]

Hi @CRUANO,

Do you mean you would like average weighted curve be filtered by the selected values in the slicer? 

It would be better if you could share some sample data and show the expected data with selected projects in the slicer visual. 

Best Regards,
Qiuyun Yu 

[CRUANO]

Could you see the data that I recently uploaded? would really be of enormous help some contribution from your part, thanks in advance...

[v-qiuyu-msft]

Hi @CRUANO,

It seems provided data isn't raw data. Would you please share the sample data you in Data tabs? 

Best Regards,
Qiuyun Yu 

[CRUANO]

That´s it!

I enclose an example of the data with its development in the year and three example categories on which the data can be grouped without distinction.
The intention is that the cumulative annual progress curve would be recalculated according to the categories that are chosen in the slicer.

Thanks in advance.

	Budget	Project category 1	Project category 2	Project category 3	1/01/2018	1/02/2018	1/03/2018	1/04/2018	1/05/2018	1/06/2018	1/07/2018	1/08/2018	1/09/2018	1/10/2018	1/11/2018	1/12/2018
Project 1	2.808.783	A	D	I	0,0%	0,0%	0,0%	5,0%	20,0%	40,0%	50,0%	60,0%	70,0%	80,0%	90,0%	100,0%
Project 2	4.170.517	C	G	I	2,2%	5,9%	8,0%	10,0%	17,0%	24,0%	39,0%	49,0%	59,0%	75,0%	85,0%	100,0%
Project 3	3.475.206	C	G	I	20,0%	40,0%	74,0%	90,0%	92,0%	94,0%	96,0%	98,0%	100,0%	100,0%	100,0%	100,0%
Project 4	6.109.402	C	D	I	0,0%	0,0%	0,0%	0,0%	5,0%	15,0%	40,0%	50,0%	60,0%	70,0%	80,0%	90,0%
Project 5	1.586.970	A	G	I	2,2%	8,0%	15,1%	27,3%	42,9%	57,0%	71,8%	79,9%	86,7%	91,9%	100,0%	100,0%
Project 6	392.758	C	D	H	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	10,0%	35,0%	60,0%	100,0%	100,0%
Project 7	2.842.171	B	G	H	0,0%	0,0%	0,0%	0,0%	1,0%	5,0%	15,0%	30,0%	40,0%	70,0%	90,0%	100,0%
Project 8	1.022.865	C	F	H	0,0%	0,0%	0,0%	0,0%	0,0%	15,0%	45,0%	75,0%	100,0%	100,0%	100,0%	100,0%
Project 9	1.020.647	C	D	J	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	40,0%	80,0%	80,0%	100,0%	100,0%	100,0%
Project 10	2.341.199	B	D	K	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	15,0%	45,0%	80,0%	100,0%
Project 11	830.000	B	D	K	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	5,0%	15,0%	30,0%	40,0%	100,0%
Project 12	2.018.484	A	D	J	9,1%	31,8%	54,5%	77,3%	95,0%	100,0%	100,0%	100,0%	100,0%	100,0%	100,0%	100,0%
Project 13	1.948.571	B	F	K	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	3,7%	23,0%	51,9%	80,7%	100,0%
Project 14	1.837.501	A	E	J	0,0%	0,0%	0,2%	0,6%	1,2%	1,5%	18,1%	38,1%	54,0%	100,0%	100,0%	100,0%
Project 15	255.728	A	E	K	8,1%	15,4%	24,0%	32,4%	41,0%	49,4%	58,0%	66,6%	74,9%	83,6%	91,9%	100,0%
Project 16	1.560.098	A	E	J	0,0%	0,0%	0,0%	0,0%	10,0%	30,0%	40,0%	60,0%	70,0%	80,0%	90,0%	100,0%
Project 17	1.508.000	B	E	K	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	0,0%	15,0%	25,0%	40,0%	55,0%	75,0%