Forum Discussion
Kathi
3 years agoNew Member
Line Chart with Starting Point and Variable Monthly Values
Dear All,
I am currently struggling to create a line chart that shows the following:
I have a starting value of 10.000 EUR. Every month new actuals will be uploaded and they vary (see example in table below). Instead of showing the actuals in a line chart (which I was able to do), I want to show the values in the column "Starting Value". However, I am not sure how to calculate this in Power BI, so it automatically takes the new starting value every month and reduces it by the current actuals.
| Month | Starting Value | Actuals |
| Jan-23 | 10.000 | 250 |
| Feb-23 | 9.750 | 1.000 |
| Mar-23 | 8.750 | 2.570 |
| Apr-23 | 6.180 | 3.800 |
| May-23 | 2.380 | 1.400 |
| Jun-23 | 980 | 980 |
I hope it is clear, what I mean. If not, please let me know.
Thank you very much in advance for your support. It is much appreciated.
Best regards,
Kathi
No RepliesBe the first to reply