Forum Discussion
Automatic recalculation on average weighted curve
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 eac...
v-qiuyu-msft
Community Support
Community SupportHi 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
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% |